Good Morning
I have a formula that I use for ranking our sales reps based on their sales. The formula I have in place now, works, except that when there are multiple sales reps with the same sales amount they should all be the next ranked number and then resume ranking starting with the next ascending number. If that doesnt make sense, please see the example below, The last column is what it should be and the RANK column is what the formula is currently doing.
Here is the formula: =RANK(N6,$N$6:$N$67,0)+COUNTIF($N$6:$N$67,N6)-1
RSR Total RANK Should Be:
Ron Valdez 228 1 1
Kiran Patel 218 2 2
Carl Misch 216 3 3
Franc DiStefano 207 4 4
Jason Young 203 5 5
Ross Randolph 200 6 6
Abi Dickerson 198 9 7
Dean Goodman 198 9 7
Paul O'Keefe 198 9 7
Nick Mercado 189 10 10
Bookmarks