I need to find the average of the 3 smallest numbers from a column. Please see columns T, U, V, W
With the condition that they need to be higher then a certain number eg 60, 120, 180, 240
We had an operator just work on it and we thought they were correct but slightly out.
Example V2 should = 212.66 which is the average of the 3 minimum numbers from column N that are above 180.
If you sort column N you will notice the 3 lowest numbers will be 211, 213, 214. The average this = 216.66
Solved by V. L. in 21 mins