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????