By using this site, you agree to our Privacy Policy and our Terms of Use. Close
Michael-5 said:
non-gravity said:

In my Excel I don't understand what IF(MAX() part accomplishes under Entrant in the Platform and Weekly tabs. I think with only the VLOOKUP part you'll be fine.

I don't understand what you just said....you "Entrant" tab only lists people in the order they are written in at the very start.

In my Platform and Weekly tabs in the Entrant column there's a VLOOKUP that selects the names in order of their ranks for which it uses the ugly brown ranking tables in the Data tab. Then in the rest of the table it look up the name under entrant and selects all that person's scores. Thus all tables are automatically ranked by score.

Then in the Rankings tab it takes all the data that's already ranked from Platform and Weekly.

I'm still willing do make this work for you, as when it's done you don't have to spend any time ranking everything yourself.