•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Returning the second result from MATCH
I've recently made a hobby of tracking winrates in shows I watch. I'd like to add a rankings table at the end of my spreadsheet, but as seems to have plagued many people, the MATCH function only ever returns the first match in the case of a tie.
The gold-colored table functions using the retrieved cell addresses in the boxes on the right. As long as those cell addresses are correct, the table will function. I would like to tie-proof #2 and on so that they don't return the same value twice. I've been at this for a couple days now, but all the other solutions I've found have been extremely specific to the spreadsheet that the OP is using.
I'm working in Excel 2019. Link to the spreadsheet here.
[link] [comments]
Want to read more?
Check out the full article on the original site