View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joshann
 
Posts: n/a
Default Top 10% and Bottom 10%

I have a set of numbers. I want Excel to tell me which numbers are in the
top 10% and which numbers are in the bottom 10%. For example, say the
numbers a

45
23
26
21
5
10
32
11

Which of those numbers are in the top 10% and which are in the bottom 10%?
The values of the numbers will change, so I want to create a formula that
will work on the numbers.

Thanks!