How to countback a shooting score using excel

Microsoft Excel 2003 (full)
November 4, 2010 at 00:15:26
Specs: Windows XP
I am trying to work out how to perform a cout back when 2 or more shooters have the same score. Example shooter1 : vvv5v5v5v5 = 50. 6 Shooter2 : 555vvv5v5v= 50.6. I am using column C for the Score (50.6) Column E for the countback, Column D for the placings (1st, 2nd etc). I need to display the count back in column E and dispay the placings in Column D. There cannot be multiple 1 st place or any other placings either. The count back might not be used in all shootings but it can arise especialy in large comps.


See More: How to countback a shooting score using excel

November 4, 2010 at 05:12:27
Although I am not familiar with the term "countback", this technique will eliminate ties:

e.g. With your scores in C1:C10, enter this in E1 and drag it down:

=C1 + ROW() * .0000001

This will increase the values in Column C by a small multiple of the Row in which the score resides. The more zeros you use, the smaller the difference. This could make a difference depending on the precision of your scores.

Granted, the problem with this method is that the further down the column a given score is, the higher the rank. For example, if your names are in alphabetical order, Joe A's score of 50.6 will always be less than Joe Z's score of 50.6 since the Row number for Joe Z will be higher.

You could include the RAND function in there someplace to make the increase more random, but there is no guarantee that RAND won't return a duplicate number at some point. Chances are slim, but it could happen.

Report •

November 7, 2010 at 19:18:39
Thank you for your help will take this on board.

Report •
Related Solutions

Ask Question