Hi,

How about if the last coloum A14 is blank ? This fomula get the result with
"#N/A",I hope to get "-" instead of "#N/A"

Thanks.

"Bob Phillips" wrote:

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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TQ" wrote in message
...
Hi,I would like to get the data from same row or same coloum(which last
figure shown in same row or colum).

Example as below,

A1=15/3/2008
A2=25/4/2008
A3=nothing shown
A4=nothing shown
A5=Yes
A6=No
A7=nothing shown

A15 = I hope I can get the last figure or date or word shown in the
same column (ie.No).

If all the coloum is blank then show with "-" , any solution ?

Thanks.