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