Hello all.
I'm trying to rank upset picks based on the percentage of correct picks and then the number of correct picks. I'm using a combination of the RANK.EQ, SUMPRODUCT and COUNTIF. My goal is that if there are several ties with the percentage, then the tie breaker should be the number of correct picks. (i.e. if three players all have a 100% correct picks and Player A made 5 picks, Player B made 10 picks and Player C made 2 Picks, then Player B should be ranked 1, Player A ranked 2 and Player C ranked 3). For the most part I think that is working, but as it goes down the nineteen players, the ranks of 12, 14 and 19 are missing.
I've attached my sheet and I hope all of this makes sense. Thank you in advance for your time and assistance.
Bookmarks