Chip,

Brillliant! You've saved me hours of work with my mark sheets. Thanks so
much!

"Chip Pearson" wrote:

You can get the average of the top 10 entries with the following
formula

=AVERAGE(LARGE(A1:A12,ROW(INDIRECT("1:10"))))

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit it later. If you do this properly, Excel will
display the formula enclosed in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Lynne" wrote in message
...
can this be done? I have 12 entries in a row...need the top 10
averaged,
lowest 2 discarded.