Assuming your table is in A1:A3 I would try something like and the most recent will always be the last I would try something like:
=INDEX(B1:B3,MAX((A1:A3=A5)*ROW(A1:A3)))
as an array formula (confirm with ctrl+shift+enter)
Assuming your table is in A1:A3 I would try something like and the most recent will always be the last I would try something like:
=INDEX(B1:B3,MAX((A1:A3=A5)*ROW(A1:A3)))
as an array formula (confirm with ctrl+shift+enter)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks