Display Percentile

[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?

 

[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.

 

[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.

 

[BLR]

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

 

[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.

 

[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.

 

[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.