Determine average of largest 5 numbers in a column.
 

I would like to be able to determine the average of the largest 5 numbers in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44

Determine average of largest 5 numbers in a column.
 

Hi,

Try this

=AVERAGE(LARGE(A1:A80, {1,2,3,4,5}))

Mike

"Charlie" wrote:

I would like to be able to determine the average of the largest 5 numbers in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44

Determine average of largest 5 numbers in a column.
 

Try the below

=AVERAGE(LARGE(A1:A80,{1,2,3,4,5}))

If this post helps click Yes
---------------
Jacob Skaria


"Charlie" wrote:

I would like to be able to determine the average of the largest 5 numbers in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44

Determine average of largest 5 numbers in a column.
 

(Excel 2007)

Try this:

=AVERAGE(MMAX(A1:A80,5))

--
Biff
Microsoft Excel MVP


"Charlie" wrote in message
...
I would like to be able to determine the average of the largest 5 numbers
in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44

Determine average of largest 5 numbers in a column.
 

Hi

Try this formula:

=(LARGE(B1:B80,1)+LARGE(B1:B89,2)+LARGE(B1:B80,3)+ LARGE(B1:B80,4)+LARGE(B1:B80,5))/5

Regards,
Per

"Charlie" skrev i meddelelsen
...
I would like to be able to determine the average of the largest 5 numbers
in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44

Determine average of largest 5 numbers in a column.
 

Seems to be a typo somewhere here?
--
Bernard

"T. Valko" wrote in message
...
(Excel 2007)

Try this:

=AVERAGE(MMAX(A1:A80,5))

--
Biff
Microsoft Excel MVP


"Charlie" wrote in message
...
I would like to be able to determine the average of the largest 5 numbers
in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44

Determine average of largest 5 numbers in a column.
 

Seems to be a typo somewhere here?
=AVERAGE(MMAX(A1:A80,5))

Ooops!

Technically not a typo, but not a native Excel function.

MMAX is a function in the Morefunc add-in. So, if the poster has the
Morefunc add-in installed then it'll work.

--
Biff
Microsoft Excel MVP


"Bernard Liengme" wrote in message
...
Seems to be a typo somewhere here?
--
Bernard

"T. Valko" wrote in message
...
(Excel 2007)

Try this:

=AVERAGE(MMAX(A1:A80,5))

--
Biff
Microsoft Excel MVP


"Charlie" wrote in message
...
I would like to be able to determine the average of the largest 5 numbers
in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44