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!
|