One way courtesy of Harlan Grove
=LOOKUP(2,1/(1-ISBLANK(A1:A1000)),A1:A1000)
if you are looking horizontal just change to
=LOOKUP(2,1/(1-ISBLANK(A1:Z1)),1:1)
--
Regards,
Peo Sjoblom
"BGarcia" wrote in message
...
What function or macro would I use to return the last list information in
a
given range of row even when some cells are left blank?
|