MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

"Min 4" function?

  Asked By: Raynard    Date: Nov 20    Category: MS Office    Views: 859

My Excel table contains numeric values in a column. I need to calculate the
average of the 4 smallest values. I know how to write a macro to solve this, but
since this file is shared with many others I can't use a macro due to security
reasons (potential macro viruses). Does anybody know a FORMULA which finds the 4
smallest values? The MIN function only gives me the smallest value, but not the
next 3.



1 Answer Found

Answer #1    Answered By: Coleman Smith     Answered On: Nov 20

The function  you're looking for is SMALL. To find the average of the 4
lowest numbers in a range (let's call it 'mRange') you'd use:


Didn't find what you were looking for? Find more on "Min 4" function? Or get search suggestion and latest updates.