Forum Discussion
Solved
Create a ranking
In a sports ladder (just a list of players, not a league, nor tournament) a player (the challenger) can challenge another (the opponent) who is up to three places above them. If they win, they move a...
You may still be reeling so I have had a first cut at incorporating your data
Dragging the corner of the matches table down should incorporated additional matches as would adding further data. The stats columns could be added as required.
Many thanks Peter. The outcome is what I'm after.
The formulae from NikolinoDE helped me to get the other columns set up, so this is good progress!
I'm not an advanced user, and so have to apologise now for the next question - how do I adjust it for my spreadsheet that I shared images of, and where do I place the code?
I can't even see on your spreadsheet where the formula is, or where it's pointing to.
I've tried to understand it and it's a level above my knowledge or guestimatability 😞
p.s. You attached the spreadsheet - is it possible for me to do that? (I'm new to this forum).
Most of the things I have described this far are standard features of Excel 365. Something I tried specific to your problem, was to form two arrays
and then use TOCOL to reduce the stacked array to a single column, ignoring the #N/A errors, to give the updated ladder.