There was a minor flaw in your formula. The OFFSET function's initial range
was in Row_1. The MATCH function's data began in Row_3. Consequently, we
need to account for the Row_2 gap by adding 1 to the RowOffset value:
Copy that formula down as far as you need.
Regarding the ROWS($47:47)....
When the formula is copied down, that part only generates an incrementing
series of numbers (1, 2, 3, 4, etc). The LARGE function uses those values
to return the 1st largest column number, 2nd largest column number, etc.
I hope that helps.
Bookmarks