I am using excel 2000.
I have a fairly large spreadsheet (27,000 rows, 11 columns), and have used
the auto-filter function which works fine - except:
how do I get a display of the "xxxx of xxxx records found" information where

I recently upgraded to Office2003 and the Recently Used file List option is
greyed out and not available.  How do I get it back??

I have a cell say "C2" containing a dropdown list for "small biz",
"corporate" and "enterprise". I have another cell say "C5" that refers to
cell "C2".
a. If user select "small biz" in C2, C5 will show a price of say $1000.

Can anyone advice me how to concatenate two conditions in a "IF" formula?
Thanks and regards.
Ringo

Is there an enumerated constant that defines the maximum number of
characters that can be displayed in a cell, e.g., "xlMaxChars" (I just made
this one up).

I have an html file that displays data in a table format.  I can open
this file with Excel and it will display all the data in the proper
format.  I would like to automatically apply grid lines to this data as
I open the file.  The html file name will vary (generated by Webview

        I need to do a graph in excel a stacked column which contain
five blocks, but what I also need is to have one block next to thi
one to compare the two blocks, I hope this makes sense, any hel
appreciated

Is there a way, using VBA, to determine the version of Excel that is
running?

I have a column where I enter the ID number of web page, and then select
Hyperlink and enter that information for the cell.
The Hyperlink is in this format: http://www.someplace.com/detail.asp?id=1234
The ID number (ex. 1234) is the only thing that changes for all of the cells in

Does Excel have an Input Mask function?
I took the certification test and one of the questions, if I remember it
correctly, wanted me to change a column of numbers so they had "SN" in front
of them.  I think perhaps I was getting Excel confused with Access, but I

I have one workbook that is supposed to pull info from another.  The other
workbook has a named range on one of its sheets.  Here is my formula:
=IF(VLOOKUP($A63,'Client summary
report.xls'!Volumes,8,FALSE)<1,"0",VLOOKUP($A63,'Client summary