In your reply in Negative Values on the 28th you stated:-
<The formatting options only apply to the cells selected at the time the
options are applied. If you want a whole row/column/worksheet to be
affected, all of that row/column/worksheet must be selected.>

Sort sequence rules place blank cells at the end of both ascending and
descending sorts which is what I want.  However, cells that contain "" are
sorted before numbers in descending sorts, which I don't want.  I create a
conditional formula to test for division by a cell that is ...

I have some prices in cells A1 to A20 I know how to get the average price if
all the cells have a price in it, but how do I get an average if say only
some of the cells have the information in them.
ie if 10 cells have a price and 10 cells dont I could divide by 10 to get an

I want to create a worksheet that I can sell to people. To stop them passing
it on to non-paying people, I want to find a way to generate passwords that
will be unique to each customer by using data on their PC.  Does anyone have
any idea how this could be done?  I would be ...

If the holiday vector in NETWORKDAYS(start,end,holiday_vector) contains any
"null" strings (i.e. they've had the value "" inserted), then NETWORKDAYS()
returns #VALUE!
Any ideas how to get around this? I do need to have the empty cells - the

I have a CommandButton1  on Sheet1. I'd like to tell it, once clicked to go
to the last Blank cell in Sheet1 Column A. Thanks in advance!

This is my current countif statement:
=COUNTIF(J3:J33,"<-10")
BUT, I want to count anytime the cells are 10 or greater positive or negative.
Please help!

How would you float a commandbutton like when you click view, toolbars,
visual basic, and the tool bar floats where ever you're on the screen?

i have many data of shipment date of some products, the shipment date may
from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show
those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me
can use macro to make it but i can't figure out how to do.

How do I associate numbers to words in Excel please?

Is it possible to sort information containing certain data from one sheet
into other separate sheets/workbooks for that particular data? Ex.. Main
sheet contains all information on baseball teams. I want to sort out the
cubs, put the data on it's own worksheet, and update ...

Is there a function that I can use to work in degrees/minutes/seconds or
would I have to convert to decimal degrees?

Let's say I want to calculate the average of these numbers:
40, <14, 20, <14, 60
I want the average to show <29.6 but when I do the average function
=average(a1:a5) excel ignores the two <14 and gives the average of 40.

i like to change the color of the data i key in automatically,  eg. the
condition is "if data keyed in is less than 12.36 or more than 14.36, the
data is turning red color."
not sure it can be done or not. thx.

My formula is C1=SUM(A1: B1). I want to use IF function. If A1 and B1 is
blank C1 should be blank. Right now it show C1=0