Greetings,
I would like for a worksheet to search a
particular column for
the last numeric value...that is to say the last value
(cell) that is an
an actual number and not the "IF" scenario I created which
if the conditions
do not meet any of the criteria set then the cell is left
with a "N/A"
to show nothing occured. I would like it to search the
column down until
it finds the last number in it and then perform some
calculation.

The calculation (math) I don't have any problems with its
just this "search"
function, I've tried a couple different things but I can't
seem to hit it.

Exammple:

A B C D
1 Q R 12 S

2 Q R 13.5 S

3 Q R 10 S

4 Q R N/A S

Q=SOME TEXT VALUE
R=SOME TEXT VALUE
S=SOME TEXT VALUE
C COLUMN IS THE NUMERIC COLUMN WITH THE "N/A" value that
ends the search
for the last cell (C3) that has the last numeric value.
The cell in C column
will change for each worksheet.

Thanks,
J. Badinger