On Fri, 6 Jan 2006 07:33:02 -0800, "pdberger"
wrote:

Hello to all --

I have a table of monthly production figures for various people, who range
from full-time to very part-time. To track performance, I'd like to average
the top 2/3 highest producers. Here's the kicker -- I anticipate that, over
time, the actual number of people that comprise the top 2/3 will vary, as the
department grows and shrinks.

I guess I have two options:
1 -- manually use the LARGE function repetitively, adjusting the number as
things change over time.
2 -- figuring out how to do this in VBA.

Is there another formula that will count the number of items, compute 2/3rds
of them, and then pick that number of the largest numbers from the group?

Thanks in advance.

How do you figure the highest 2/3 producers?

If you define it as the 2/3 of the producers who have the highest production,
then the following might work:

=SUMIF(Production,""&SMALL(Production,CEILING(COU NT(Production)/3,1)))/
COUNTIF(Production,""&SMALL(Production,CEILING(CO UNT(Production)/3,1)))

where Production is the named range containing the quantity of production (e.g.
A2:A500).


--ron