asked on

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

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?

ASKER

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

The above people are the bottom 20%

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

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...?

This will give the top 20

`=LARGE(Range,20)`

and this the bottom 20

`=SMALL(Range,20)`

ASKER

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__.

ASKER

Tom

I'm still working on understanding your formula.