Apr 13 2020 12:46 PM
Apr 13 2020 01:04 PM
@suyankjain Not sure if you need O365, or just a new version of excel. I don't know of another way of doing this, sorry.
Apr 13 2020 10:01 PM
@suyankjain This formula will find the value in A for the last entry "TINA" in B.
=INDEX(A:A,MAX((B:B="TINA")*ROW(B:B)),1)
If you have an older version of Excel you may have to confirm entry with Ctrl-Shift-Enter. That will put "curly brackets" around it. Not sure though.
Apr 14 2020 12:13 AM
Apr 14 2020 07:48 AM
@Sergei Baklan what kind of sourcery is this? I tried to research how it works but can't even figure out how to explain what i'm seeing... 2nd argument would result either in 1 or div/0.
Apr 14 2020 10:36 AM
Second parameters always returns error or 1. LOOKUP ignores all errors and works from left to the right, thus since we lookup value 2 never will be found, LOOKUP returns the last appeared. Since we have third parameter, it returns the value form it taken for the position of last appeared in second parameter.