phyraverse
New Member
- Joined
- Sep 16, 2022
- Messages
- 1
- Office Version
- 2021
- Platform
- MacOS
I am having trouble figuring out the best way to get my formulas to keep an updated ranking system that shows who is in what place during our game.
For those who haven't played the Mario Party Games I am trying to accomplish the following. Players will earn Stars and Coins. The ranking system goes off of who has the most stars and if people are tied with stars the higher placement goes to who has more coins.
I need my ranking sheet to display and automatically update what player is in what place based on that criteria from the scoring sheet.
I have attached a link to a copy of my spreadsheet if anyone wants to play around with it.
Copy of Scoring
For those who haven't played the Mario Party Games I am trying to accomplish the following. Players will earn Stars and Coins. The ranking system goes off of who has the most stars and if people are tied with stars the higher placement goes to who has more coins.
I need my ranking sheet to display and automatically update what player is in what place based on that criteria from the scoring sheet.
I have attached a link to a copy of my spreadsheet if anyone wants to play around with it.
Copy of Scoring
Last edited by a moderator: