Get data with certain conditon

[TQ]

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

 

[Max]

This might suffice
In A15: =LOOKUP(10^10,A1:A14)

 

[TQ]

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

Thanks.

 

[Max]

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 ?

---

 

[TQ]

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]

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)

---

 

[TQ]

Hi,

How about show "-" replace of "#NA" if get nothing from certain column ?

Thanks !

 

[Max]

How about show "-" replace of "#NA" if get nothing from certain column ?

Trap the expression's return with an IF(ISNA(...),... construct
In A15:
=IF(ISNA(LOOKUP(2,1/(A1:A14<>""),A1:A14)),"-",LOOKUP(2,1/(A1:A14<>""),A1:A14))

Spare me a moment to press the "Yes" button below, won't you?
I'm under the weather of late, need the "greens" to perk me up

---