MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010
And
MaxIF to calculate largest.
These are two User-Defined functions (short as UDF) built in VBA Macros

Watch a working file from my OneDrive cloud here


Public

Tested

My Own Work
Excel 2016 (or Excel 365) comes with a lot of new features, one of them is MAXIFS and MINIFS functions. to calculate largest or smallest numbers based on multiple conditions.
What we are having here is MaxIF and MinIF to calculate based on ONE condition only.

If you have Excel 2016, you will not need this, it is only for Excel 2010 (and some Excel 2013 users) where we do not have MaxIFs nor MinIFs.

Views 1973 Downloads 718

VBA-Excel Math
ANmarAmdeen
655
Revisions

v4.0