Jan 23 2021 01:11 PM
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
Jan 23 2021 03:08 PM
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.