Average
What formula would I use the get the average of each set subtracting the MIN
and MAX out of each? Judge 1 10 10 Judge 2 8 8 Judge 3 9 9 Judge 4 9 9 Judge 5 9 9 Average Total |
One way
=TRIMMEAN(A1:A10,0.2) or written =TRIMMEAN(A1:A10,2/COUNT(A1:A10)) Regards, Peo Sjoblom "Runfst2win" wrote: What formula would I use the get the average of each set subtracting the MIN and MAX out of each? Judge 1 10 10 Judge 2 8 8 Judge 3 9 9 Judge 4 9 9 Judge 5 9 9 Average Total |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com