My Excel table contains numeric values in a column. I need to calculate theaverage of the 4 smallest values. I know how to write a macro to solve this, butsince this file is shared with many others I can't use a macro due to securityreasons (potential macro viruses). Does anybody know a FORMULA which finds the 4smallest values? The MIN function only gives me the smallest value, but not thenext 3.
The function you're looking for is SMALL. To find the average of the 4lowest numbers in a range (let's call it 'mRange') you'd use:=AVERAGE(SMALL(mRange,1),SMALL(mRange,2),SMALL(mRange,3),SMALL(mRange,4))