Posted 01 September 2006 - 08:59 AM
Yes, that's better. But it's not 100% clear to me at what point you need help. The entire workflow, from data entry to evaluation, or basically, the bottom line, of some rank order. Assuming the latter,
Lookup in help, under statistical functions, various ways to analyze the data.
Alternatively, type "=" in a cell adjacent to your scores, press "fx" on the main menu to get to Statistical functions and read the parameters of RANK function and LARGE function. Setup the functions using GUI, by selecting cells and ranges with the mouse.
RANK will tell you relative rank of a number within a range of numbers.
LARGE will return 1st, 2nd ... Nth largest numbers within a range of numbers, where data source could be the rank values calculated previously, if I understand your design.
One or both of those should give you what you need, and you can follow up more in how to combine the information from those two columns of data.