I have a list of data. want to get the lowest non-zero value. How to set up
the formula?
Thanks!

i have 5 yrs of revenue data.  however, 2 of those yrs had significant spikes
because of unusual circumstances.  i would like to hihlight this fact - i.e
say that the total revenue for a spike year was $2M, but that $900K was due
to extraordinary circumstances.  also i am showing ...

Formula now is =B3/E3/F3*G3 I need the results to round up in increments of
3. Example if results are even, 3,6,9,12 etc... thats fine but if it's
something like 3.9 I need it to round up to 6, 7.1 up to 9 etc... Thanks in
advance

I am trying to limit user input to a range of cells to one of 15 single
letters or blank only.  I can get the data validation tool to limit to a
single text character, but i can not seem to get it to limit it to the 15
"approved" text letters.  Can any one give me any ideas ...

What am I doing wrong? Column A I've got =countif(a:a,2)=1 because I don't
want duplicate numbers entered. No matter what is entered even numbers that
aren't duplicates, I still get my warning message and won't allow me to enter
anything. Thanks in advance!!

hi to all
This is simple I'm sure, but it sure is stumping this new user.  I
frequently get .xls sheets that I must save as .csv format before the data
can be loaded into a database.  Here's my problem:

I have a table below and I want to delete all material rows except the newest
date/last purchase date. Any suggestions
material    purch date
A    1/2/2008

Would like to know how you can locate the Workbook/Sheets Cells that contain
Formula and External Links.

When I select non-adjacent cells, the highlighted boxes disappear on me and I
cannot see which cells are selected. How can I fix this?

In Excel 2007 when I select a range of cells, rows or columns the area
darkens slightly so you can see what you are selecting...is there a way to
make this highlighting darker without having to actually color the cells.
Thanks,

Is it possible to make the Find and Replace box bigger so that the text is
easy to read?
Many thanks

For some reason I cannot fill color in cells and cannot change the color of
fonts in cells.  I can change borders around cells or groups of cells, but no
cells can be filled with color and I cannot change font color in any cells.  
I have tried repairing Office 2003 and have tried ...

I want to change the gridlines' by default to be changed to Pale Blue color.
Any Idea?

I have a schedule sheet that I want to extract only the lines in which
have "PIP" in the Format column.
I could do it with a filter but that seems pretty messy on line
numbering.

Hi I'm relatively new to macros and looking for some help and/or direction to
an online source for macro development help.  I have columns of data and for
one column I would like to count the number of entries that lie within
certain ranges.  For example: