=INDEX(A1:A10,MATCH(FALSE,ISBLANK(A1:A10),0))
array entered (ctrl+shift+enter)
However if your values are always number then this should do
=LOOKUP(999999999999999,A:A)
assuming the looked up value is in column A
"BerlinUSA" wrote in message
...
I am needing assitance in finding a formula that allows me to find the
value
of the last nonblank cell in a range.
|