Question: how to find average of best two numbers in excel?
Answer: Enter this formula: =AVERAGE(IF(A2:A20>SMALL(A2:A20,3),IF(A2:A20<LARGE(A2:A20,3),A2:A20))), (A2:A10 is the data range that you want to average, the number 3 indicates the number of the largest and smallest value, if you want to average ignoring the largest and smallest 10 values, you just need to change it to 10), then ...