Display Percentile

B

BLR

In column A I have a list of nuimbers. I ran a conditional format to
highlight certain ranges of percentiles (above 80% and above 90%). Is there
a way to get column B to acutally display what the percentile is?
 
R

Rick Rothstein

Does putting this formula in B1 and copying down give you what you want?

=10*INT(A1/10)

Change the A1 to A2 and put the formula in B2 if you have a header row.
 
L

Luke M

If you already have a formula for the condition format, it sounds like part
of that formula would have to be calculating what the percentile is, and you
could use that in column B.
 
B

BLR

I used the Conditional Formating wizzard so I dont know what the formula is.
All I can see is the rule.
 
B

BLR

That did not seem to work. I just got 10 returned back in every row. I
checked to see if it was adjusting each row and it was.
 
R

Rick Rothstein

My formula assumes your numbers are integers (such as 39, 62, 78, etc.). Can
you give some examples of the actual numbers you have in Column A and show
us how the cells are formatted.
 
S

Spiky

In column A I have a list of nuimbers.  I ran a conditional format to
highlight certain ranges of percentiles (above 80% and above 90%).  Is there
a way to get column B to acutally display what the percentile is?

I believe PERCENTRANK is designed for this.

B1: =PERCENTRANK(A:A,A1)

Format to percent/decimal places and copy down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top