Ranking on particular percentage of data from any range

[zonexs123]

Hello Experts,

I have a sheet where there are three column: User, Total Point & Rank in which there are 23 records. What I want is to assign ranks as per following condition:

Top 10% should get rank 1
Top 80% should get rank 2
Remaining 10% should get rank 3


I have also attached a sample sheet for this.

Appericate your prompt response.



Thanks,
Santosh

[6StringJazzer]

Ranking scores=Rating.xlsx

Attached is one solution. Note that your data is sorted in descending order of score, so my solution assumes this will always be the case (that assumption makes the solution much simpler).

I also assume that you meant the middle 80%; if it were the top 80% then it would also include the top 10%.

Also note that the percentages do not always work out to round numbers. For example, in your sample there are 23 items. My solution looks for the largest number less than 0.10 so you only get two items ranked 1. Similar for 80%, and then that leaves 3 for the remaining 10% due to rounding error.

[zonexs123]

Thanks a lot... its worked for me now....