Comparing Numbers in a Trivia Game speadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2090428%22%20slang%3D%22en-US%22%3EComparing%20Numbers%20in%20a%20Trivia%20Game%20speadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090428%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20working%20on%20an%20Excel%20speadsheet%20for%20a%20Trevia%20game.%20My%20question%20is%20as%20the%20player's%20totals%20are%20added%20at%20the%20end%20of%20each%20set%20of%20questions%2C%20I%20want%20to%20put%20their%20position%20(1st%20place%2C%202nd%20place%2C%20etc.)%20in%20another%20row.%20I%20have%20no%20problem%20sorting%2C%20but%20how%20do%20I%20then%20establish%20the%20correct%20position%20for%20the%20corrent%20player%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EGinny%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2090428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.