Excel MIN IF Array Formula
© Ted French
Similar to the previously mentioned Excel MAX IF array formula is the MIN IF array formula.
The one difference of course is that it uses the MIN function to find the smallest value in a given list of data.
The IF function is used to set conditions so that you can control what data is used by a formula, and the array formula lets you carry out multiple calculations in a single cell.
To find out all the details, read this tutorial on the Excel MIN IF Array Formula.
Related Tutorials
Comments
No comments yet. Leave a Comment