The formula below returns the last number in a single, changing column of bank balances.
I don't know how it does it.
I think I pulled it from this site before registering; it's the quality of the answer that prompted me to join. So...
I have read several explanations of how INDEX and MATCH work together, and "how powerful they are" blah blah; but have yet to encounter an explanation that I can understand. To assist with anyone who offers an answer -- I am not a beginner.
How does this work? What does the first argument in MATCH do?
Thanks for any help.
INDEX(I472:I1032,MATCH(9.99999999999999E+307,I472:I1032))
Bookmarks