Hi,
I use the Index/Match formula to find the last active cell in a column quite effectively.
I'm wondering though how to adapt it to find the second last active cell?
EX: Last active cell formula:
Data:
a 10
b 11
c 0
d 12Is it possible to use INDEX/MATCH to return the second most recent active cell, in this case, B2?Please Login or Register to view this content.
Thanks!
Bookmarks