Why the array suggestion?

It eliminates text including formula blanks.

The first formula won't.

The way things go for me is, I'd post only the first formula then the OP
would follow-up with " it doesn't work, I get a blank cell ???"

So, I just tried to cover all the bases without getting into overkill!

Biff

"Ragdyer" wrote in message
...
You're confusing me Biff.<g

Why the array suggestion?

First one works fine for text *AND/OR* numbers, though it *also* returns
nulls, which of course can be very confusing if displaying an 'empty'
appearing cell.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
Hi!

Try one of these:

If the range will ONLY CONTAIN NUMBERS (empty cells are ok) and no TEXT
including formula blanks:

=LOOKUP(2,1/(C2:C250),C2:C25)

Or, if there might be TEXT entries, entered as an array using the key
combination of CTRL,SHIFT,ENTER:

=INDEX(C2:C25,MAX(IF((ISNUMBER(C2:C25))*(C2:C250) ,ROW(C2:C25)-ROW(C2)+1)))

Biff

"Conker10382" wrote in message
...
I want to create a formula in a cell that will make that cell display the
value of the last cell in a column with a value greater than 0.
i.e.:
A B C D E
1 500 <----
2
3 17
4 75
5 500 <----