Use of Percentile / Percentrank Function

[vaidehee]

Hi,

I would like to know if there is any formula that would help me in ranking the data. A typical scenanio would be that: The sales team has performed very well, , however we would need to identify the top 10% ,30%,40%,19%,1% team members of sales. Is there any formula wherein this can be done. I have tried percentile but some how it cannot give me accurate date. Can anyone help

 

[Sal Paradise]

Like this perhaps?

Excel Workbook
	A	B	C
1	Name	Sales	Percentile
2	Andy Alfa	9	100.00%
3	Bernie Bravo	8	77.78%
4	Chris Charlie	9	100.00%
5	Danny Delta	2	22.22%
6	Ernie Echo	6	44.44%
7	Fanny Foxtrot	7	55.56%
8	Greg Golf	8	77.78%
9	Herman Hotel	2	22.22%
10	Innes India	4	33.33%
Sheet1