formula for selecting ans averaging

  • Thread starter Thread starter larryb
  • Start date Start date
L

larryb

Hello: I have a data row from a3 to z3 that is added to weekly. I need a
formula that will select the top 10 values from the row and average them
out. Changing the answer as the data is entered . The data input will range
from - 0 to 65. thanks
 
In A4:

=LARGE(3:3,COLUMN())

Copy to the right to column K

Somewhere:

=AVERAGE(A4:K4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello: I have a data row from a3 to z3 that is added to weekly. I need a
| formula that will select the top 10 values from the row and average them
| out. Changing the answer as the data is entered . The data input will range
| from - 0 to 65. thanks
 
In A4:

=LARGE(3:3,COLUMN())

Copy to the right to column K

Somewhere:

=AVERAGE(A4:K4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hello: I have a data row from a3 to z3 that is added to weekly. I need a
| formula that will select the top 10 values from the row and average them
| out. Changing the answer as the data is entered . The data input will range
| from - 0 to 65. thanks
Click to expand...

If you want to do it in just one simple formula you can try this:-

=SUM(LARGE(3:3,{1,2,3,4,5,6,7,8,9,10}))

Using curly brackets around the list 1 to 10 creates an array which
means you don't need to use any more than this formula.

Hope this helps,
M.Richardson
http://teachr.blogspot.com
 
Back
Top