Display Percentile
 

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?

Display Percentile
 

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.

--
Rick (MVP - Excel)


"BLR" wrote in message ...
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?

Display Percentile
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"BLR" wrote:

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?

Display Percentile
 

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"BLR" wrote:

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?

Display Percentile
 

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" wrote:

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.

--
Rick (MVP - Excel)


"BLR" wrote in message ...
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?

Display Percentile
 

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.

--
Rick (MVP - Excel)


"BLR" wrote in message
...
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" wrote:

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.

--
Rick (MVP - Excel)


"BLR" wrote in message
...
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?

Display Percentile
 

On Dec 4, 10:42*am, BLR wrote:
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.