Can someone help with a formula to find out the Average of the 5 best numbers out of 6 in a range?
I know you need to find the farthest number from the mean of the 6.
A1 = 1.00105
A2 = 1.00116
A3 = 1.00177
A4 = 1.00096
A5 = 1.00108
A6 = 1.00098
I know you need to find the farthest number from the mean of the 6.
A1 = 1.00105
A2 = 1.00116
A3 = 1.00177
A4 = 1.00096
A5 = 1.00108
A6 = 1.00098