Apologies if the example is a bit weird, but the idea is the same for the formula.
Let me know if there are any questions or concerns.
| A | B | C | D | E | F | G |
|---|
| 2 | ID | Designation | Years of Experience | Salary | | | |
| 3 | 445533 | Senior Director | 20 | $139,267.00 | | | |
| 4 | 309440 | Director | 20 | $107,904.00 | | | |
| 5 | 119136 | Senior Director | 19 | $120,382.00 | | | |
| 6 | 548464 | Vice President | 17 | $176,110.00 | | Designation | Vice President |
| 7 | 346154 | Senior Manager | 18 | $109,233.00 | | Years of Experience | 17 |
| 8 | 482527 | Director | 18 | $110,771.00 | | Salary | $175,000.00 |
| 9 | 677523 | Vice President | 17 | $189,551.00 | | Percent Rank | 0.597 |
| 10 | 747621 | Manager | 17 | $95,595.00 | | | |
| 11 | 744377 | Vice President | 17 | $170,735.00 | | | |
| 12 | 858280 | Senior Director | 16 | $144,234.00 | | | |
| 13 | 362728 | Vice President | 17 | $119,485.00 | | | |
| 14 | 225064 | Director | 16 | $117,874.00 | | | |
| 15 | 242118 | Senior Manager | 14 | $95,048.00 | | | |
| 16 | 159112 | Senior Director | 14 | $140,049.00 | | | |
| 17 | 464903 | Director | 14 | $116,064.00 | | | |
| 18 | 959997 | Manager | 13 | $92,020.00 | | | |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Salary Data (2)
Array Formulas
| Cell | Formula |
|---|
| G9 | {=PERCENTRANK.INC(IF(Table134[Designation]=G6,IF(Table134[Years of Experience]=G7,Table134[Salary])),G8)} |
|---|
<thead>
</thead><tbody>
</tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>
