•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
Tagged with
#enterprise-level spreadsheet solutions
#AI-driven spreadsheet solutions
#no-code spreadsheet solutions
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#big data management in spreadsheets
#AI-native spreadsheets
#google sheets
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#MATCH function