# Trying to determine top 20 and bottom 20 percent of a group of 23

Trying to determine top 20 and bottom 20 percent

I have 23 people.  They are ranked in order of priority below.

1-James
2-Judy
2-Alex
4-Tony
5-Terry
5-Lisa
7-Paul
7-Sandy
10-Felix
12-Don
12-Ned
12-Alfred
12-Edward
12-Bob
17-Tim
17-Raymond
17-Chris
20-Nelson
21-Pedro
21-LeAnn
21-Andrew
21-Kevin
25-Tucker

Is something than can be done in excel? Or perhaps some simple formula on a calculator?
Karen Falandays

I would use conditional formatting. Select the data. Click Home>Conditional Formatting>Top/Bottom rules
Tom Farrar

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.

Ok. This is great, and it's close. However, the top performers would be the lower numbers. When I use the top/bottom rules, the top 20% are

 21 Pedro 21 LeAnn 21 Andrew 21 Kevin 25 Tucker

The above people are the bottom 20%

The top people actually those rated with lower numbers, with 1 being the top priority

 1 James 2 Judy 2 Alex 4 Tony

If the count was the same, I'd like to say they're actually the top 20 and bottom 20. With the diff on count, I'm unsure...?

You can modify the rules. Select the data. Home>Conditional formatting, manage rules. Now click to edit and modify the contingents to your requirements.

This will give the top 20

``=LARGE(Range,20)``

and this the bottom 20

``=SMALL(Range,20)``
Ignore the "1" and ":" that the Beta generates.
SOLUTION

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.

Thanks Karen

I'm trying to figure out the correct rule to place the top and bottom 20 %  to as those with the lower and higher numbers in the priority column.

Tom

I'm sure this is a great way to break it down. To me though, it's latin. Can you explain what you're formulas are doing? Sorry... I wish I knew excel. I apparently need a class

Marin

How would I apply this to my current workbook?

How would I apply this to my current workbook?
I'm sorry but I missed the word "percent" in your question and the formulas I gave select the largest and smallest values.