There is a better way to break ties in your rankings than the workaround you are likely building right now. The MATCH function's single-result limitation is not a flaw you have to accept, it is a constraint that can be elegantly bypassed with a small structural shift in your approach.
The user tracking winrates in their spreadsheet has run into the classic MATCH problem: when two entries share the same value, the function always returns the first occurrence. Many people respond by stacking helper columns or resorting to fragile array formulas that break when the data changes. The better solution is to introduce a tiebreaker into the lookup key itself. By appending a small, incremental decimal to each tied score, based on that row's position in the original data, you create a unique identifier for every entry. The MATCH function then has no ambiguity, and your rankings table returns the correct order every time, even when scores are identical.
This technique works across versions of Excel, including the 2019 edition the user mentioned, and it does not require any volatile functions or complex nested formulas. The practical outcome is a rankings table that updates reliably as you add new data. Instead of manually verifying cell addresses or adjusting formulas after every new episode, you build a system that handles ties automatically. The spreadsheet becomes a tool you trust, not a project you manage.
The user's real insight was recognizing that the default behavior of MATCH was the bottleneck, not their own formula-writing ability. That is the kind of clarity that separates a frustrating workaround from a durable solution. If you are building a rankings table and hitting the same wall, do not spend another day searching for a bespoke fix specific to your layout. Apply the tiebreaker principle once, and your spreadsheet will handle ties as cleanly as it handles single results.