I have 2 spreadsheets, each from a different source.  Both spreadsheets
contain a store number, SKU and SKU quantity except one of the spreadsheets
includes SKUs that the other one doesn't . . .  and v/v.  I need to create a
report that compares both spreadsheets and returns the ...

I am working on putting together a cheat sheet.  I guess you could describe
it as a dashboard.  I was wondering if you could combine then split cells.  I
would like to go from 3 cells to 2 cells.  I don't want to affect the entire
column as I will have a table below that needs ...

I have dates in column A and a calculated # in column B.  What I need to
determine is for a specified date range from col A, how many in col b are
less than or equal to 1.  For example:
Date range = 02/01/2008 to 02/10/2008 should return a value of 2.  I can't

I have a worksheet that I can scan but it will not let me enter in any data.
How do I make it work?

Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68.
How to write formula?

Hi, ive been asked to work out the average temperature for every year from
1880-2007. The problem i have is when i put in the normal =sum(a1:a12)/12 i
need it to fill the formula so the next one is =sum(a13:a25)/12 and then the
next one is =sum(a26:38)/12 etc etc ,when i try it ...

I am trying to link worksheets in a way that allows a sheet to be auto
updated when I add a comment or format the color of a cell. Is this possible?
So far, only the text gets updated, not the insertion of a comment, nor the
format of cell color. Please help. Thanks

I want to return the minimum value of about 13 cells in a column (column B).
I only want to include values where the text in column K is TRUE (based on a
different IF formula from another cell).
TIA

I am trying to find the value of the cell directly below cell B3 in a
filtered list; the list will change constantly as new criteria are selected.  
How can I do that?
Thanks,

I would like to learn how to set a rule within a cell that will allow me a
notification when an event is coming due within Excel 2003.  If I enter a
date and I would like to be visually warned, saying the cell turns red a
month prior to the annual date to ensure that I address ...

What I'm trying to do is input a date into say cell F1, then depending on the
date I want that to generate a price in F3.
The information is:
If date is on or between

I've got a shared workbook that I track changes on the problem is I can not
copy the shared workbook to another book even if its shared also. When I
unshare the workbook my track changes disappear. How can I keep the shared
book, and copy it to another book, and track changes?

Will someone please be able to clarify,
What is the use of adding a + in front of a cell reference (ex: +C28) Using
Excel 2003?
Thanking you

I have set up a worksheet and need to add .5% to each cell. I am using the
formula ='Classified 08'!B5+('Classified 08'!B5*.5%) in each cell and out of
180 cells 30 are off by .01 some over some under.  Any ideas why this is
happening? Out of 180 cells 30 are off by .01.

Hi - Anyone out there have the way to calculate the annualised return for an
investment? Many thanks for your assistance