I have Excel 2003, I have a spreadsheet where the intent is to load various
formulae
and have them costed, there are 30 rows but not all are used each time.
I have a VLOOKUP reporting the cost to a column where I need to total the

I have spreadsheet with invoice dates on it.  I need
another column that will show aging date against
specific date that will be input in one of the cells.

I want a cell to display only if it matches certain criteria.
Basically, I am trying to display invoices that are
30, 60 and 90 days over due.  I want the cell only
to display invoice amount if the aging falls within

I have tried a few macro codes for merging several similar excel files
into one but all of them (the ones that actually worked) did not read
the 'correct' worksheet withing the XLS.
Can anyone give me a hint?

I have a group of users in a list. If they book a TV (by choosing their name
under the equipment), I want to force them to add what movie they are
planning to show in the cell below their name before they can book the TV.
I am a newbie at this and a little confused with the ...

What's the combo that sets excel such that when it is opened, it opens with
a set program rather than a blank.

I imported contacts from excel to outlook and then I needed to import the
cell phone numbers, so I imported all contacts again.  Now I have duplicate
contacts...can anyone help?

Is there a function to format a concatenation string eg
79.5% & " were recorded" comes out as .795 were recorded when using
=cell ("contents", a1) & " were recorded"
Would like it to be 79.5% were recorded. Can anyone help?

I have a simple table and I would like to have every second row in different
color.
How can I make it?
Thanks

Can some review the following IF statement. The error is stating that there are too many arguments.
=IF((TEXT((D2),"yyyy")="2007"),"2007",if(TEXT(d2),"yyyy")="2006","2006","2005 & Before")
If the year of the date is 2007, state "2007", If the year of the date is 2006, state "2006", ...

Hi all. Is there a function that will tell me if the content of one
cell, appears somewhere in a list of other cells?
Example: Sheet has 91 names in cells A10:A100
Operator enters a name in Cell A1. If the entered name appears in the

I have written a function in VBA. When I use that function in Excel it
gives me #Name!, which i think probably means that it could not find
the function. The function is defined in the same sheet.
kindly advice.

Is there a way that you can delete/remove rows of data where a specific
situation applies.  For example I want to remove the entire row where email
addresses are blank
Thanks for any help

How do I apply a "Comma Style" to a column of numbers using only the keyboard
- using shortcuts, etc.
I am tutoring a blind student and this one has me stumped!
Thanks, Bill

Is there a way in Excel to take a spreadsheet containing new price
adjustments, compare it to my current inventory, make price changes as
necessary on my current inventory spreadsheet, and , then print a list of
changed items? Or is this an Acess function?