Urgent help - Rank function

[rohanmalhotra]

Hi

i have to prepare a sheet that will give performance ratings to the employees (keeping bell curve in mind). The ratings that needs to be given are 4, 3 & 2. Can anyone help me with it?


Thanks

 

[GlennUK]

My apologies, PERCENTRANK does not operate as I thought it did from memory. Will generate an alternative now.

Like this:

Excel Workbook
	C	D
1	58%	3
2	77%	3
3	66%	3
4	51%	2
5	58%	3
6	88%	3
7	96%	4
8	100%	4
9	14%	2
10	55%	3
11	100%	4
12	13%	2
13	76%	3
14	55%	3
Sheet3

 

[rohanmalhotra]

Thanks for all your help Glenn

 

[rohanmalhotra]

I dont have words to thank u... u r a champ Glenn :D

 

[GlennUK]

My pleasure ... I'm glad I hit the right method in the end.