I need a column of data to be ranked (from lowest value to highest value). Here are some of the details:
1. The data is a column made up of distances to a certain target, ie, whomever gets the closest will rank #1 and is the winner.
2. That column of data is also the result of a formula from another column (I don't think this detail matters.)
3. I need the range to increase as the number of participants in the contest increase, ie, 5 are ranked when there are 5 participants, 6 are ranked with 6 participants, etc.
3. I need the ranking to not count blanks or zeros. (This is difficult when the participants don't go in the order that they were registered, so #5 participant may not go until the 20th turn, or #15 participant may not even have a result for this contest but might only be in the next contest, etc. So when I skip ones that don't have results to submit, and then go on to the next one, I need for that ranking formula to increase the range only by the number of cells that have actual values.
Here is a brief example. The first one would be if only 2 people had gone already.
Participant Name ........................ Total Dist (in inches).........................Rank
1. Joe................................................. 2.5..........................................1
2. Sam..................................................3...........................................2
Then, if the next participant missed his turn (but could take it later), then I need the rankings to not include him until he took his turn.
Participant Name................................Total Dist (in inches).....................Rank
1. Joe ............................................................2.5................................ 2
2. Sam ..........................................................3 ...................................3
3. Bob .......................................................... ___ (blank)
4. James .......................................................1....................................1 (See how the rankings changed? The guy who used to be in 1st place moved down to 2nd place after the 3rd guy entered his distance.)
Any other info needed?
Thanks. Really.
Bookmarks