How-To Geek on MSN

I stopped overrelying on Excel's filter buttons after learning how to build live lists

With the FILTER function, adding or changing criteria instantly updates my results, while the original data stays intact.

Excel FILTER Formula Multiple Conditions and Examples

Excel FILTER function mastery requires understanding TRUE/FALSE logic. Use the * multiplier for AND logic to easily handle multiple complex conditions.
Hosted on MSN

I stopped using the Excel filter button to find high and low values. These 2 functions do it better

Excel's filter button is useful, but I've realized I was relying on it for the wrong job. When all I wanted was the highest or lowest number that matched a certain condition, filtering meant hiding ...