Seamus2626
asked on
Ranking in deciles
Hi,
Attached i have a list of values which i would like ranked from 0-10%, 10-20% etc
I need to be able to ascertain how many of the values are in the decile range 90-100%, 10-20% etc
I have had a crack using formula i found online, however i am finding values of 275 and 0 in the percentile 10, so something is not right
Can someone have a look and amend
Many thanks
Percentrank.xlsx
Attached i have a list of values which i would like ranked from 0-10%, 10-20% etc
I need to be able to ascertain how many of the values are in the decile range 90-100%, 10-20% etc
I have had a crack using formula i found online, however i am finding values of 275 and 0 in the percentile 10, so something is not right
Can someone have a look and amend
Many thanks
Percentrank.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER