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=50
A2=3
A3=nothing shown
A4=nothing shown
A5=40
A6=nothing shown
A7=nothing shown

A15 = I hope I can get the last figure shown in the same column (ie.40).Is
that any formula able to do this ?

Thanks for help !

TQ

This might suffice
In A15: =LOOKUP(10^10,A1:A14)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TQ" wrote:
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=50
A2=3
A3=nothing shown
A4=nothing shown
A5=40
A6=nothing shown
A7=nothing shown

A15 = I hope I can get the last figure shown in the same column (ie.40).Is
that any formula able to do this ?

Thanks for help !

TQ

Thanks for reply, I tried, but get the result with "#N/A".Actually, what's
the meaning of (10^10) ?

Thanks.

"Max" wrote:

This might suffice
In A15: =LOOKUP(10^10,A1:A14)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TQ" wrote:
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=50
A2=3
A3=nothing shown
A4=nothing shown
A5=40
A6=nothing shown
A7=nothing shown

A15 = I hope I can get the last figure shown in the same column (ie.40).Is
that any formula able to do this ?

Thanks for help !

TQ

"TQ" wrote:
Thanks for reply, I tried, but get the result with "#N/A".
Actually, what's the meaning of (10^10) ?

10^10 is 10 to the power of 10, a very large number
I'm not sure why you get the error
The expression works ok over here
Maybe try it again ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks a lot ! I got the answer exactly with 40.I got another question.How
about if those data within these column is date and not number or some words
? Can I still get the date or words show in the column I sepecify ? Any
formula can do this ?

"Max" wrote:

"TQ" wrote:
Thanks for reply, I tried, but get the result with "#N/A".
Actually, what's the meaning of (10^10) ?

10^10 is 10 to the power of 10, a very large number
I'm not sure why you get the error
The expression works ok over here
Maybe try it again ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"TQ" wrote:
Thanks a lot ! I got the answer exactly with 40.

Good. But do press the "Yes" button below

How about if those data within these column is date
and not number or some words

Real dates are numbers, btw.

To get the last whatever (number or text) within A1:A14
In A15: =LOOKUP(2,1/(A1:A14<""),A1:A14)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---