Hi.  I am currently using the STDEV formula.  Is there a way, that i can make
the formula use data from nonblank cells, only.  For example: A1, A2, A5 will
have numbers listed.  A3 & A4 are blank.  Can i get the formula to use only
A1, A2, & A5?  

If I have quite a complex sheet set up that uses random numbers to lookup
into a series of tables and produce a series of results, with a
button/associated onclick event set up
what is the best (if any?) way to append various cell results to a new row

I have a spreadsheet as per the enclosed attachment. The top date is
always Today's date, regardless of when the spreadsheet is opened. The
rest of the dates are Today's date plus 1, plus 2, plus3, etc.
Therefore, the dates are moving up the table, day by day. The Saturdays

I'm trying to compare 3 tables (same fields) to check and see if any data is
different.  The layout is the same only the data will be different (Base
Table, Current Table, New Table)
Table 1: Base

My problem:   get a cell to produce a pop up message when it exceeds a
certain value and do not restrict the entry value?
I tried Data - Validation but have had no luck.
The details (much simplified) are these:

I have a long list.
Column A contains Account Names (many repeated)
Column B Contains Orders  (many repeated)
Column C Contains Invoice Cost.

Hey guys
I have this logic expression in a spreadsheet
=IF(C19>C18,"YES","NO")
What i want to do is if it returns a value of NO make the text red.

I need to set up a range within an IF function for specific cell reference.
For example if I have a range from 2.5 to 3.0 I want =IF(A2>=2.5,"B2",0) as
well as =IF(A2<=3.0,"B2",0) in the same A2 cell. Excel always tell me I have
too many arguments. It seems simple to get a range. ...

Is there a way to increase the number of lines (it seems to be 8) displayed
at a time (without scrolling) in a data validation dropdown list?
Thanks,
Stefi

How do I calculate how many Mondays, Tuesdays, Wednesdays, etc. were
worked in a month based on this:
A1       B1
Date    Day of Week (based on calculation)

I have an RC type formula and I want to dynamically change the end value
based on an entry in A2.  I'd prefer to keep IF statements out of it if
possible.  
If A2=1, I want it to be

I have a list of employee on one worksheet and on the second worksheet
worksheet I created a search engine ... but i need to display the information
of the result of the search on the second worksheet. I need the result to say
display all the employee that are 24 years old ....

I have set up the following if formula what I have done wrong -
As follows:
if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000, if(g8>244500,
4000))))

Hi Guys
I have a problem, and am not too good in excel ...  and am not
financial wizard so please be patient :-)
The file I am working with is available  'here

I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either?  Here
is what I am trying to do.
I want say cell A1 (this will be the variable)