When I use the formula referencing the pivot table in Excel 2003 instead of just showing the cell reference it shows the GETPIVOTDATA. How to get just the...

but I want to look in both columns for the same value. Column 1 has 20 different depts as 'inputs' adn column 2 has the same 20 as outputs - I want to filter...

Hi All, Need your help guys...MS Excel 2007 i have data from one file and want to move it to another file. with data like: A1 Refill, 100 respondent, 100...

I'm using Excel 2007. I don't know when the problem started, but the problem is continuing to give me trouble. The problem is that when I resize the window,...

Is there anyway I can input a number in excel and have excel link that number to a invoice templete I created automatically? I am not very familiar with...

I am familiar enough with excels formula - what ifs etc but I was wondering if it is possible to construct the following formula: I have an excel sheet full...

Is there a way I can convert all my files in Excel 2003 to Excel 2007 without having to go into each file? -- Carmen

Hi Is there a way to conditionally format a column of dates just using the days and months and not including the year? For instance, the column I have is...

Basically.. Column A is a list of names Column F is the total amount of hours practice the named person has done I want a Fuction which automatically tells...

Does anynone know which matrix multiplication algorithm is implemented by Excel 2007? Thanks in advance

Hi. I want to create a time sheet where a user logs in at a time then logs out at a time, I want Excel to then calculate the number hours and minutes. I...

I have a large spreadsheet that someone must have attempted to past into without using text or unicode text options. As a result it added hundreds of...

I have an exceldokument with 30 sheets and would like to print the names of the sheets in a list. Someone who knows how that works?

I'm attempting to use VLookup() to access data in the 7th column of a different sheet in the same workbook. I have named the range that I want as "Have",...

Hi, I have the following formula to subtract the dates from two different columns: =IF(DATEDIF(Z11,AD11,"m")=0,"",DATEDIF(Z11,AD11,"m")) What i want the...

I would like to copy particular cells from nine different worksheets and paste (value only) to another sheet named “Print�. All the sheets are within one...

I have a list of email addresses in excel. I need to be able to paste those addresses into an email so I need to export the column of email addresses to...

I have a table that contains names that have a time, category, the number of times that the name uses the category, and the total time the name uses the...

Is it possible to link a cell from the "Previous Sheet" without giving it a name. I need to link about 400 cells on a sheet and need to copy it to another 30...

Hello all, could someone please help... I work in a school and am trying to create a tracking grid to map pupil progress. I need to count the number of times...