| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | Org | Sales Team | Average Deal Margin % | Percent Rank | |
2 | (high) | 50% | |||
3 | SellCo | Adriene Neisler | 44% | 91% | =PERCENTRANK(c$2:c$13,c6) |
4 | SellCo | Christi Marron | 39% | 82% | |
5 | SellCo | Dalene Savino | 33% | 64% | |
6 | SellCo | Eric Costas | 36% | 73% | |
7 | SellCo | Greta Landi | 27% | 36% | |
8 | SellCo | Iluminada Thomason | 32% | 46% | |
9 | SellCo | Inger Narron | 32% | 46% | |
10 | SellCo | Lesli Kjos | 22% | 18% | |
11 | SellCo | Nguyet Elks | 23% | 27% | |
12 | SellCo | Valrie Lum | 16% | 9% | |
13 | (low) | 10% |