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.
Have you ever struggled to sort data in Excel in a way that truly fits your needs? Imagine trying to organize a list of regions not alphabetically, but in a specific order like “North, South, East, ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results