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.