I would like to pick a name from a drop down list and use the selected name
in a formula.
I have set up the names and entered the values. I have created the drop down
list but whenever I try to use the name selected my formula does not treat

In column A filled with text, i need to find the full text which contain a
phrase that is equal to cell B1 and list them all on Column C.
e.g.
A    B    C

I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM
extension. It takes about 1 minute to open up, and then is quite sluggish
and prone to breakdown.
I saved it as an XLS file, and remarkably, it saved it with a few Kbs less,

In cell A2, there is char 2328050010001023841.
I am not sure whether the char is text or number, does anyone have any
suggestions on how to force it into number?
I have tried following code, but it misses the last 4 digits.

I have run a vlookup function, there are "#value!" shown on some cells.
How can I change these cells to blank, I dont want to show "#value!".
I have use =ISERROR((VLOOKUP.............)), but there is still a "1" shown
in the cells. I dont want to show anything in the cells when the ...

I would like to write a macro to print out below information from
INVOICE NO. "2008-005" TO "2008-020"
I have write macro :  firstinv = inputbox("input the first invoie")
                              lastinv= inputbox("input the last invoie")

I have run a vlookup function, there are "#value!" shown on some cells.
How can I change these cells to blank, I dont want to show "#value!".

This probably has an easy solution but I just cant figure it out. I have
search this discussion board but cant find anything.
Anyways I was wondering if there is a formula that sums the last 7 entries I
entered in the row.

i would like to know how to formulat a cell so each time the number in the
cell will increase by 1 or 5. there will be 5 people who access  this file
only one at a time.

In A1 a number is enter : let's say 1 to 120.
Results in B1 will be :
if A1 = 1,2,3,11,12,13,21,23 OR 25 then B1 will show GRAPE
if A1 = 4,5,6,7,8,9,10 OR...            then B1 will show LEMON

I have two columns with 1000+ numbers in them.  Column 1 is the correct
column.  I want to compare columns 1 and 2 and move those in #2 that don't
match or appear in #1 to a third column.  End result should be #' 1 and 2
match and a third column contains #'s that were in #2 but ...

I have a spreadsheet that covers the year daily from Jan01 - Dec31. It
includes employees names and their shift pattern.
What I would like Excel to do if possible is to count the number of
instances an employee is off .. i.e. if an employee works Mon-Fri as their

A friend has an Excel workbook that does not require the use of the = sign to
begin a formula.  In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula ...

Hello: I know you can show codes for formulas by pressing Ctrl +~
Can you do something similar to show codes for Validation? I have a
complicated Excel worksheet that has many variations on Validations- some are
to named cells, some are to groups of cells etc.

i am working on a spread sheet. i have set up that everytime i enter a number
the cell next to or two down adds 250 when i enter the first number is it
possible to make the cell with the added 250 turn red.