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
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.
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 4,041
Downloads 1,107
CodeID
DB ID