MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010
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

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 1062 Downloads 392

'Excel', 'macros enabled', 'max', 'min', 'maxif', 'maxifs', 'minif', 'minifs', 'udf', 'function', 'user-defined', 'calculation'

Math VBA-Excel