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?

 

Thanks

Ginny

3 Replies

@slowginfizz 

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

image.png

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