Comparing Numbers in a Trivia Game speadsheet

Copper Contributor

Hi, I am working on an Excel speadsheet for a Trevia game. My question is as the player's totals are added at the end of each set of questions, I want to put their position (1st place, 2nd place, etc.) in another row. I have no problem sorting, but how do I then establish the correct position for the corrent player?




3 Replies


It depends upon how your results are presented and what version of Excel you are using.  For example, in Excel 365 you could have


Sample data in a workbook might get you some more targeted replies, though.