Formula help to find Top 20%

[bflan0524]

hello
looking for a formula to find what the average is for the top 20% of clients, middle 20% bottom 20% etc
for example if column A lists a bunch of % and Column B had a list of $ values, what is the average for the top 20% in column A, middle etc

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]Change %[/TD]
[TD]$ Value[/TD]
[/TR]
[TR]
[TD]22.97%[/TD]
[TD]$129,0000[/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

Hi,

This is a question open for interpretation. What do you mean by top 20% of a list as by your example?

Is top20% the 20 highest %-numbers in the range and subsequently the bottom 20% are the 20 lowest %-numbers?
Or
is is top 20% the top 20% of the available lines, eg if this the list is 30 lines, the top20% is 6 lines hence an average of 6 lines with the highest %-numbers?

can you eloborate on that and provide a desenzitized set of data to use.

 

[bflan0524]

my apologies, yes the top 20%, middle and bottom from a performance standpoint

 

[jorismoerings]

The addition of % in your answer of 'Top20%' opens the question again.

So can you provide a set of sample data with a mockup of you're asking a formula for.