Re: Average of Numbers in Top 5

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

=AVERAGE(LARGE(A1:A100,ROW(INDIRECT("1:"&E1))))

Array-entered, where E1 holds the nth largest value to include in the average.

HTH
Jason
Atlanta, GA

"Jake" wrote:

> Thanks, now what if I want the number (10 in this case) to be variable based
> on a referenced cell?
>
> "Bob Phillips" wrote:
>
> > =AVERAGE(LARGE(A1:A100,{1,2,3,4,5,6,7,8,9,10}))
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Jake" <Jake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:4371FC1A-D128-46C1-A1BF-1719D68B2E1C@xxxxxxxxxxxxxxxx
> > > How do I tell excel to look at only the top x numbers in a list of values?
> > > For example, if I have 100 scores and I want Excel to calculate the
> > average
> > > of the top 10 scores, how do I do that?
> > >
> > > Thanks
> >
> >
> >
.

Relevant Pages