How-To Geek on MSN
I stopped using the Excel filter button to find high and low values. These 2 functions do it better
Once you start using multiple criteria, MAXIFS and MINIFS make light work of questions buried in your data.
There’s a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years. Excel’s MINIFS() and MAXIFS() functions identify ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results