05-02-2007, 08:19 PM
The problem with your solution is that you lose the ability to measure how people did relative to each other on their n-th attempt, which may or may not be a significant piece of information.
To avoid this you could also create formulas in the 14 cells adjacent to each person's score and use the =LARGE(range, k) function to choose the first largest, then the second largest, then the third...then drag those formulas down across each person's set of scores.
To avoid this you could also create formulas in the 14 cells adjacent to each person's score and use the =LARGE(range, k) function to choose the first largest, then the second largest, then the third...then drag those formulas down across each person's set of scores.