In cell G7 is =SMALL(C7:E7,1)
Trying to use =IF(ISERROR funct to return a blank cell instead of #num! when
C7:E7 are blank
Please advise

Currently I select a column and then chose "Text to Columns" then "Finish"
and the green triangle will vanish from cells within this column.  I know
there is a way to copy a cell with the correct format and paste this format
to all selected cells using paste special but when I do ...

What I need is for todays date to show in a cell if a value equal to or
greater than one is placed in another cell.  For instance, on an ordering
form if a one is placed in a qty ordered cell todays date would show up in
the last ordered cell.  Hope that makes sense.  I have been ...

Dear Anyone,
I have prepared a few excel files linked together and am planning to sell it
to a company. But they may copy and give these files to other companies to
use on their computer. I want to protect my work. Giving passwords to open

When scrolling the mouse in Excell the page moves horizontal instead of
vertical.
How do I correct it so the page moves vertical?

I'm using MS Excel 2000 (9.0.3821 SR-1) and I need far more rows than
the 65,536 that I think it allows.  I only need about 14 columns if that
helps.  Can I increase this number of rows?  I'm thinking 150,000 to
200,000?

I have made a mistake in a cell but then saved it.How can I go back to the
info that I had before I saved the new one.Is it possible to restore the old
info or have a restore date?

In what version of Excel was Filtering introduced? I have Excel 97 and the
Help file talks about it but the program doesn't seem to have it. (eg, No
down arrows at the tops of the columns.)

What it the maximum number of worksheets that can be used in one Excel file.
I'm using Excel 2002 if that makes a difference.
Thanks.

I have the following formula in a cell, sometimes my answer will be  "
exception "
=IF(ISNA(VLOOKUP(J38,'2006 Monthly
Sales'!$E$2:$Q$386,10,FALSE)),"",VLOOKUP(J38,'2006 Monthly

hi there - i'd like to multiply a variety of cells by the same cell - so, i'd
like to multiply the information in cell A1 by the information in b1 through
b10 and c1 through c10 and d1 through d10.
is there a way to set up the formula so that when i copy and paste the a1*b1

I have made a hospital porter tracking spreasheet. I have drop down colomns
with, where the porter is going (from and to) and the porter who is doing the
job and colomns with the now formula, which I have used validation for them
all. I can type in the data which is in the drop ...

I have created a calendar that will shade out the weekends.  I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.
In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last ...

I have a folder full of *.CSV files, and I'm able to import them into a
workbook by using the Import Data command, but this only imports a single
file at a time. I would like do import all of the csv files without having to
import each one.

I need to have list down the left side that goes from 100-520 but everytime I
try and drag the list down it goes from adding 10 to just adding 1.  I type
100,110,120,130 and drag and it switches to all 100.  I also need to have
Percentages on the top row.  40%-95% going up by 5%. ...