How can I calculate the average of 5 best out of 7.. or best 10 out of 15..
For example if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I only
want it to take the average of the best 7.. I really appreciate your help..
Thank you!

Eyad

Hi!

if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I only
want it to take the average of the best 7..

What do you consider to be the best 7?

Biff

"Attempt at solving a Matrix Problem?"
oft.com wrote in message
...
How can I calculate the average of 5 best out of 7.. or best 10 out of
15..
For example if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I
only
want it to take the average of the best 7.. I really appreciate your
help..
Thank you!

Eyad

You could use the LARGE worksheet function and program in as many
formulas as numbers that you want to assess, then take the average of
the numbers that this gives you.

This wouldn't be very efficient though, you really need an array
formula and I aren't all that good at making them!


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=471491

Hello,

Oh Sorry, The best out of 7 could be the highest 7 numbers.. or even the
lowest 7 numbers.. either way..
Thank you

Eyad

"Biff" wrote:

Hi!

if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I only
want it to take the average of the best 7..

What do you consider to be the best 7?

Biff

"Attempt at solving a Matrix Problem?"
oft.com wrote in message
...
How can I calculate the average of 5 best out of 7.. or best 10 out of
15..
For example if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I
only
want it to take the average of the best 7.. I really appreciate your
help..
Thank you!

Eyad

Here is a solution based upon a suggestion in John Walkenbach's Excel
2003 Formulas. Enter the following array formula in a single cell:
=AVERAGE(LARGE(ColumnRange,ROW(INDIRECT("1:3"))))

Here ColumnRange is the given range of numbers. In this example, the
average of the largest 3 is computed.

George Monahan

I attempted it, but this only takes the largest out of them all.. I put the
numbers in Rows also..

Eyad

"xlmaven" wrote:

Here is a solution based upon a suggestion in John Walkenbach's Excel
2003 Formulas. Enter the following array formula in a single cell:
=AVERAGE(LARGE(ColumnRange,ROW(INDIRECT("1:3"))))

Here ColumnRange is the given range of numbers. In this example, the
average of the largest 3 is computed.

George Monahan

Average of top 7 out of 10 (located in A1:A10)
=AVERAGE(LARGE(A1:A10,{1,2,3,4,5,6,7}))

Average of top 10 out of 15 (located in A1:A15)
=AVERAGE(LARGE(A1:A15,{1,2,3,4,5,6,7,8,9,10}))

Average of bottom 7 out of 15 (located in A1:A10)
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6,7}))

Average of bottom 10 out of 15 (located in A1:A15)
=AVERAGE(SMALL(A1:A15,{1,2,3,4,5,6,7,8,9,10}))

"Attempt at solving a Matrix Problem?" wrote:

How can I calculate the average of 5 best out of 7.. or best 10 out of 15..
For example if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I only
want it to take the average of the best 7.. I really appreciate your help..
Thank you!

Eyad

I appreciate it very much, Thank you All for your help.. visit me at my
website http://emarzuq.4t.com.. Thanks again

Eyad

"Sloth" wrote:

Average of top 7 out of 10 (located in A1:A10)
=AVERAGE(LARGE(A1:A10,{1,2,3,4,5,6,7}))

Average of top 10 out of 15 (located in A1:A15)
=AVERAGE(LARGE(A1:A15,{1,2,3,4,5,6,7,8,9,10}))

Average of bottom 7 out of 15 (located in A1:A10)
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6,7}))

Average of bottom 10 out of 15 (located in A1:A15)
=AVERAGE(SMALL(A1:A15,{1,2,3,4,5,6,7,8,9,10}))

"Attempt at solving a Matrix Problem?" wrote:

How can I calculate the average of 5 best out of 7.. or best 10 out of 15..
For example if I have 10 different numbers. 10,7,9,8,5,6,7,5,6,7 but I only
want it to take the average of the best 7.. I really appreciate your help..
Thank you!

Eyad