how do i average the 3 max numbers in a column?
Hi Mike
Try the below for average of max3 and min3
=AVERAGE(LARGE(A:A,{1,2,3}))
=AVERAGE(SMALL(A:A,{1,2,3}))
If this post helps click Yes
---------------
Jacob Skaria
"Mike" wrote:
Hi, i have a list of numbers in a column (not in any particular order) and i
would like to average the 3 max numbers and 3 min numbers. is there a
function that can do this?
|