This appears to return the contents of the last cell in a specified column
whether that cell holds a number or text...

=LOOKUP(2,1/(A1:A65535<""),A:A)

Rick


"gwbdirect" wrote in message
...
I need a formula that will show the last cell in a range.
1000
2000
3000

want to show 3000 as the result and not the total of everything in the
column!!!