LOST!! Chart? Pivot table? Formula?

I have a column of numbers (lengths of time). I am supposed to find the
point at which 90% of the numbers are below. Yes, I write these reports -
but usually I put in the numbers they give me. Now I must spin the straw
into gold myself! Can someone help a word-smith figure out numbers?

Ed

Ed,

You could use Conditional Formatting and this formula to highlight the times that are below the 90th percentile.

Select the first cell in your range of times (in this case A1), click on Format>Conditional Formatting. In the CF option box, change the Cell Value Is to Formula is: Type in this formula.

=A1<PERCENTILE($A$1:$A$16,0.9)

Select the fill color you want and click ok. Click on the format painter (it looks like a paint brush) and highlight the rest of your range and release the mouse button. This will apply that format to the entire range. The cells that are highlighted are below the 90th percentile for the range of times.

Does that help?

Steve

Use =PERCENTILE(A1:A500,0.9) to find the 90% percentile.
90% of numbers are below this

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:%[email protected]...
>I have a column of numbers (lengths of time). I am supposed to find the
> point at which 90% of the numbers are below. Yes, I write these reports -
> but usually I put in the numbers they give me. Now I must spin the straw
> into gold myself! Can someone help a word-smith figure out numbers?
>
> Ed
>
>

Thanks, Steve. I appreciate the boost.
Ed

"SteveG" <[email protected]> wrote in
message news:[email protected]...
>
> Ed,
>
> You could use Conditional Formatting and this formula to highlight the
> times that are below the 90th percentile.
>
> Select the first cell in your range of times (in this case A1), click
> on Format>Conditional Formatting. In the CF option box, change the
> Cell Value Is to Formula is: Type in this formula.
>
> =A1<PERCENTILE($A$1:$A$16,0.9)
>
> Select the fill color you want and click ok. Click on the format
> painter (it looks like a paint brush) and highlight the rest of your
> range and release the mouse button. This will apply that format to the
> entire range. The cells that are highlighted are below the 90th
> percentile for the range of times.
>
> Does that help?
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=514991
>

Thanks, Bernard. I appreciate the boost.
Ed

"Bernard Liengme" <[email protected]> wrote in message
news:%[email protected]...
> Use =PERCENTILE(A1:A500,0.9) to find the 90% percentile.
> 90% of numbers are below this
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
> news:%[email protected]...
> >I have a column of numbers (lengths of time). I am supposed to find the
> > point at which 90% of the numbers are below. Yes, I write these
reports -
> > but usually I put in the numbers they give me. Now I must spin the
straw
> > into gold myself! Can someone help a word-smith figure out numbers?
> >
> > Ed
> >
> >
>
>