rep 1 had 7 #1s over 15 opportunites
rep3 had 6 #1s over 15 opportunites as well

"smartin" wrote:

Vercingetorix.XIII wrote:
I need some help creating a formula to calculate who was at #1 status the
most throughout the month. Some people were not on list everyday and some
were, so I have to take into account for that. example:

a b c d e f g h i j k l m n o p
1 Rep1 1 1 1 2 1 2 2 2 1 3 1 2 3 3 1
2 Rep2 2 1 2 3 3 1 2 2 2 1 4 4 4
3 Rep3 3 1 1 3 3 1 3 3 1 1 1

I am sure you get the picture, I tried a few different ones but I have to
have an accurate avg score at end of month, can someone please help????


It depends on your scoring rules.

Rep1 had 7 #1s over 15 opportunities (47%), average score = 1.7.
Rep3 had 6 #1s over 11 opportunities (54%), average score = 1.9.

Who wins?