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
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 )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.