in the attached the formula in E5 is to return the average of the smallest 3 numbers in D5:D10. reference in g5 returnsthe correct value of {1,2,3} but when used in the formula of Average(small($D5:$d10,g5)) the contents of g5 is returned as "{1,2,3}". this causes a value error.
Bookmarks