Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Raynard Fischer on Nov 20 In MS Office Category.

"Min 4" function?

Question Answered By: Coleman Smith 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:

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

View Complete Question Thread

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

Related Topics:

screen goes blank after 15 min of inactivity screen saver set for 130 mins
find min and match
20 Mins Process in Application Server
How to get MIN, MAX and AVG of a variable sized table
cant keep the system to stop going to sleep after 1 min
min of memory/hd and processor speed to install ubuntu
min of 384MB of memory
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

Tagged:min function

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us