General

what is the maximum number of rows excel for mac 2008?
... 20 Mar 2010 23:17

Unable to copy formula from one cell into 2 or more consecutive ce
I have a Gateway laptop NX 860 XL, with a 2ghz Intel Core 2 duo and 2 gigabytes of RAM running Windows 7. The system originally came with Windows Vista and MS Office 2007 Standard. I did an upgrade install to Win 7 last October. MS Office is currently at SP2. All updates are applied automatically so everything ... 23 Mar 2010 00:09

Auto Populate
I need to contact someone who has some pretty extensive knowledge of excel that can help me fix my workbook. i can send a copy to you so that you could be able to take a look at it. i have an weekly agenda that i populate with a data list. can i get it to auto populate other sheets when i select which day i... 19 Mar 2010 17:50

Skip Reference Sequences during copy
Cell A1 countsif a value appears in cells b1; b2 or b3. I want to copy cell A1 into cell A2 etc but want the countsif reference to jump to b4; b5 or b6. Currently if I copy it down to A2 the reference changes to b2; b3 and b5. I need to copy hundreds of cells like this and I'm trying to avoid doing it manuall... 20 Mar 2010 16:38

Vlookup with If condition
A1 A2 A3 1 3 4 2 5 6 3 6 3 4 7 8 5 3 2 6 2 1 7 3 9 I am trying to find a combination formula that looks at column A2 for a specific value from another cell (say the cell value is 3 in this case). If column A2 though contains the value "3" as this... 19 Mar 2010 15:32

help with filtering
I have a document that has application information for each client in columns, not rows. For example, Joe Blow's information goes down column B (last name B1, first name B2, date of birth, B3, etc.), Jane Blow on column C, etc.--the headings for each row are in column A. The document is in this format because... 19 Mar 2010 17:50

Conditional Data Validation Options
So I have two columns of Data Validations: Column A we'll call Cost Centers Column B we'll call Accounts If somebody puts in a Cost Center for a specific department which we will call Advertising, then a different list shows up in Column B of only Advertising Accts. I use the following formula in Colu... 19 Mar 2010 14:23

Send a Sheet as body of Outlook Email
I used to be able to send an Excel sheet as a body of a message to a recipient. The recipient would be able to reply and enter information and then send it back. With 2007 the "sent to mail recipient" function seems to change the sheet to html format and the recipient cannot enter information and return the s... 19 Mar 2010 12:02

Convert From Comment to Cell Content
My admin put data into comments instead of a seperate column. How can I move/copy/convert that data from a comment to the contents of a cell? ... 19 Mar 2010 10:48

Pivot Table Filter Formula
I have a set of payroll data that I need to put into a pivot table, do some calculations, and filter but I can't figure it out. Here is what I have: Name Date Hours John Doe 1/1/10 10 John Doe 1/2/10 8 Jane Doe 1/1/10 9 and so on I want to summarize this data by week (can use the weeknum f... 19 Mar 2010 13:14