Spreadsheet: 849933d1700295321-anyone-help-with-rank-or-nested-ifs-ref-test-1
Sheet: Sheet1

 | Year to Date |  |  |  |  |  | Month |  |  | Movement
Person | Closed Lost | Closed won | Pipeline | Grand Total | Average per month | closed won conversion | Oct Referrals | Oct Conversion | Oct in play | YTD | [NAME] | Movement | People |  |  | Proportion
1 | 24 | 13 | 6 | 43 | 4.777777777777778 | 0.3023255813953488 | 4 | 0 | 2 |  |  |  | Referrer Volume |  |  | Proportion
2 | 20 | 8 | 3 | 33 | 3.666666666666667 | 0.2424242424242424 | 7 | 0.2857142857142857 | 3 |  |  |  | YTD | Oct |  | YTD | Oct
3 | 23 | 7 | 3 | 34 | 3.777777777777778 | 0.2058823529411765 | 2 | 0.5 | 1 |  |  |  |  |  | Tier 1
4 | 31 | 15 | 7 | 53 | 5.888888888888889 | 0.2830188679245283 | 5 | 0.2 | 1 |  |  |  |  |  | [NAME]
5 | 58 | 18 | 4 | 80 | 8.88888888888889 | 0.225 | 9 | 0.2222222222222222 | 3 |  |  |  |  |  | Tier 3
6 | 18 | 6 | 5 | 29 | 3.222222222222222 | 0.2068965517241379 | 2 | 0 | 0 |  |  |  |  |  | [NAME]
7 | 25 | 7 | 2 | 35 | 3.888888888888889 | 0.2 | 3 | 0.3333333333333333 | 2
8 | 21 | 9 | 4 | 34 | 3.777777777777778 | 0.2647058823529412 | 6 | 0.1666666666666667 | 5 |  |  |  | Yellow – 20% plus Closed Won conversion (3+ referrals per month)
9 | 21 | 7 | 0 | 28 | 3.111111111111111 | 0.25 | 0 | 0 | 0 |  |  |  | Blue – 20% plus Closed Won conversion (2-3 referrals per month)
10 | 11 | 4 | 4 | 19 | 2.111111111111111 | 0.2105263157894737 | 0 | 0 | 0 |  |  |  | Green – Below 20% conversion >2 referrals per month
11 | 11 | 7 | 5 | 23 | 2.555555555555555 | 0.3043478260869565 | 0 | 0 | 0 |  |  |  | Brown - <2 referrals per month
12 | 13 | 7 | 4 | 24 | 2.666666666666667 | 0.2916666666666667 | 4 | 0 | 4
13 | 16 | 5 | 4 | 25 | 2.777777777777778 | 0.2 | 2 | 0 | 2
14 | 13 | 6 | 3 | 22 | 2.444444444444445 | 0.2727272727272727 | 0 | 0 | 0
15 | 14 | 7 | 1 | 22 | 2.444444444444445 | 0.3181818181818182 | 4 | 0 | 3
16 | 9 | 8 | 1 | 18 | 2 | 0.4444444444444444 | 1 | 1 | 0
17 | 16 | 5 | 0 | 21 | 2.333333333333333 | 0.2380952380952381 | 0 | 0 | 0
18 | 62 | 14 | 12 | 90 | 10 | 0.1555555555555556 | 5 | 0 | 1
19 | 70 | 10 | 12 | 93 | 10.33333333333333 | 0.1075268817204301 | 9 | 0 | 5
20 | 86 | 9 | 9 | 106 | 11.77777777777778 | 0.08490566037735849 | 9 | 0.1111111111111111 | 4
21 | 89 | 9 | 11 | 109 | 12.11111111111111 | 0.08256880733944955 | 8 | 0 | 5
22 | 68 | 8 | 9 | 85 | 9.444444444444445 | 0.09411764705882353 | 5 | 0.2 | 1
23 | 58 | 4 | 12 | 74 | 8.222222222222221 | 0.05405405405405406 | 9 | 0.1111111111111111 | 3
24 | 69 | 6 | 10 | 85 | 9.444444444444445 | 0.07058823529411765 | 4 | 0 | 3
25 | 59 | 9 | 4 | 72 | 8 | 0.125 | 3 | 0.3333333333333333 | 0
26 | 1 | 1 | 0 | 2 | 0.2222222222222222 | 0.5 | 0 | 0 | 0
27 | 1 | 1 | 0 | 2 | 0.2222222222222222 | 0.5 | 0 | 0 | 0
28 | 2 |  | 0 | 2 | 0.2222222222222222 | 0 | 0 | 0 | 0
29 | 1 |  | 1 | 2 | 0.2222222222222222 | 0 | 0 | 0 | 0
30 |  | 1 | 0 | 1 | 0.1111111111111111 | 1 | 0 | 0 | 0
31 |  | 1 | 0 | 1 | 0.1111111111111111 | 1 | 0 | 0 | 0
32 | 1 |  | 0 | 1 | 0.1111111111111111 | 0 | 0 | 0 | 0
33 | 1 |  | 0 | 1 | 0.1111111111111111 | 0 | 0 | 0 | 0
34 | 1 |  | 0 | 1 | 0.1111111111111111 | 0 | 0 | 0 | 0
35 | 1 |  | 0 | 1 | 0.1111111111111111 | 0 | 0 | 0 | 0
36 | 1 |  | 0 | 1 | 0.1111111111111111 | 0 | 0 | 0 | 0
37 | 1 |  | 0 | 1 | 0.1111111111111111 | 0 | 0 | 0 | 0