LinkBack URL
About LinkBacks
I feel there's a simpler way, but this array (confirm with CTRL, SHIFT and ENTER) will do it:
=INDEX(B1:B20,MAX(ROW($1:$20)*(A1:A20=1)))
where you're looking for the last occurrence of 1.
Adjust ranges and the row limits to suit your data.
I feel there's a simpler way, but this array (confirm with CTRL, SHIFT and ENTER) will do it:
=INDEX(B1:B20,MAX(ROW($1:$20)*(A1:A20=1)))
where you're looking for the last occurrence of 1.
Adjust ranges and the row limits to suit your data.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks