In Date(year,month,day) function, all need to be number, what if I have month
in letter, how can I use date function?
I've tried a different way by using if, nested function only allow 7 or 8 of
them, so I can't nest the function all the way to December.

I have an excel spreadsheet with 2 sheets.  I need to return a value based
off of 2 criteria.  
Sample Data: First Sheet
A                B             C

I am stumped. My situation is I want to total let's say "A1" on multiple
worksheets but then want to average the total out by the number of
worksheets. Is there a formula that would address this?

Have a long list of identifiers:
E6A3289A
F9DB1200G5W
KRQ7356VQ

I have a worksheet with a list of docters names. Some have the acronym MD and
some do not. How do i delete the acroynm from the entire spreadsheet and
still keep the doctors names?

I'm trying to find a way to display the top 3 items in a random list of more
than 7 components.  Assuming I have the following data:  
Column A (value)          Column B (components)
2.3                                            z

Anyone has any idea why I can't validate my data using List.
I tried to set it up both ways: cell reference, and comma split.
I worked with the same sheet yesterday, and I could validate the data using
List. But when I tried today with a different cell.  The drop-down arrow sign

I tried to set up an IF criteria:
IF(A1>=10,True_Action1, Else IF(A1>=20, True_Action2, False_Action)
It seems like the formula only perform True_Action1 because criteria 2
overlap criteria one as well.  How can I fix this bug?  I was thinking

Could use a little help.
I have the date '1/20/08' in a cell displayed as '20 Jan' using NumberFormat
= "dd mmm".  Is there a way in VBA to get the '20 Jan' in a string so that I
can concatenate it with some other text?

I am wanting to use the lookup function to insert a particular value from a
list in another worksheet in the same workbook eg.
If data in A1 & B1 are present then lookup the other worksheet to find both
data values from A1 & B1 and then return the value in column C of the 2nd

Is there a save-as option instead of copying sheet from workbook to save it
separately?

I have a spreadsheet model.  Within the model are a bunch of fields
requiring input.  I wanted to have a macro that would clear all of these
fields so someone could start over.  That was the easy part.  However, I
don't want someone to click on the button that starts the macro by ...

I need a cell to read 69¢ if the amount is below a dollar, but $1.69 if the
amount exceeds a dollar. I know how to do either in FORMAT CELLS, but how do
I get Excel to see and format the cell based on this criteria?
Thank you in advance.

Trying to find all alike numbers in a column of about 5000.  Data is sorted
by number already but the list it to long to look through.  Filtering the
data only brings up another long list to have to go through. Is there a
formula that will find them  and highlight them?  There ...

Dear Sir,
I have a problem, i want to find a value or number in more than 100
worksheets at once so please help me out.
Regards,