Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

Ranking in deciles

Posted on 2014-09-30
Medium Priority
232 Views
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
0
Question by:Seamus2626

LVL 24

Accepted Solution

Phillip Burton earned 2000 total points
ID: 40351971
You are missing dollar signs around the part of the formula that says A2. It should read:

=MAX(1,ROUNDUP(10*PERCENTRANK(\$A\$2:\$A\$26875,A2,3),0))
0

Author Closing Comment

ID: 40352236
Thanks!
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses
Course of the Month11 days, 20 hours left to enroll