say i have this on a1 downwards
18000
18000
17050
16100
15200
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
I want formula on b1 , to look all data on a1 to infinity and quote me 14500 , last cell figure
say i have this on a1 downwards
18000
18000
17050
16100
15200
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
I want formula on b1 , to look all data on a1 to infinity and quote me 14500 , last cell figure
Try this:
=LOOKUP(9.99999999999999E+307,A:A)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Wow , thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks