Percentrank

[Snehasandesh]

how to calculate percent rank for employee salary with designation and no of year experienc as condition

 

[ExcelElliott]

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>