Ask Your Question
1

Question On getting Most recent Value

asked 2018-04-27 04:59:43 +0100

hunter99507 gravatar image

Im creating a sheet and want to get the most recent value So for example lets say A1=10, A2=1000, A3=100. I would like B1 to tell me the most recent value in the list which would be A3. So the answer would be 100.

But if I said A4=1 I would want B1 to show "1". Because that is the most recent.

Any help would be apprieated.

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-04-27 07:06:18 +0100

JohnSUN gravatar image

updated 2018-04-30 14:48:04 +0100

There are many ways to do this. That's one of them:

=INDEX(A:A; SUMPRODUCT(MAX(ROW(A:A)*N(A:A<>""))))

If you want use another range of column A then you need add correction factor - the number of the first row of the range reduced by one (e.g. A4:A26 will be 4-1=3)

=INDEX(A4:A26; SUMPRODUCT(MAX(ROW(A4:A26)*N(A4:A26<>"")))- 3 )
edit flag offensive delete link more

Comments

Thank you for the help and that worked but some some reason when I try to change all of the "a:a" to "A4:A26" It doesnt work at all. I am not understanding why i cant start at a4 and end at a26.

hunter99507 gravatar imagehunter99507 ( 2018-05-01 05:38:27 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-27 04:59:43 +0100

Seen: 25 times

Last updated: Apr 30 '18