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