formula for selecting ans averaging
 

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

formula for selecting ans averaging
 

In A4:

=LARGE(3:3,COLUMN())

Copy to the right to column K

Somewhe

=AVERAGE(A4:K4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"larryb" wrote in message ...
| 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

formula for selecting ans averaging
 

Try: =AVERAGE(LARGE($3:$3,{1;2;3;4;5;6;7;8;9;10}))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"larryb" wrote:
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

formula for selecting ans averaging
 

On Feb 5, 1:26 pm, "Niek Otten" wrote:
In A4:

=LARGE(3:3,COLUMN())

Copy to the right to column K

Somewhe

=AVERAGE(A4:K4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"larryb" wrote in ...

| 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