formula for selecting ans averaging

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
 
N

Niek Otten

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
 
M

Matt Richardson

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top