Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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.

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:

=AVERAGE(SMALL(mRange,1),SMALL(mRange,2),SMALL(mRange,3),SMALL(mRange,4))

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

Related Topics:

- find min and match
- 20 Mins Process in Application Server
- How to get MIN, MAX and AVG of a variable sized table
- Wait function and Invisible function
- Wait function and Invisible function
- How can I call the function TotalPrice within another function?
- help on functions
- Problems with XL's 'MATCH' function
- Excel won't calculate my function
- User Function - is optional calculation possibe?
- Automatic update of Function return value.
- String-Split Function parameter "compare"
- function as argument
- Need to create function smiliar to DMAX
- Logistic Regression (Statistical Functions)
- Wierd problem in VBA code re Mid function
- function question
- function to change the color of the cell
- User Defined Function didn't work
- How does the Worksheets function work?
- Converting Date functions
- user-designed Excel math functions
- Convert Serial Number to a Date Function
- MAPI Functions
- function that returns a String Array