Here’s an example of a basic Excel filter function formula, for example, filter how many employees stay in Florida (refer to the table): =FILTER(C5:E19, E5:E19=I1,"Florida") ...

To accomplish an AND across multiple columns, we’ll use the * symbol, which is similar to the AND() function, but AND() doesn’t work as you might expect when combined with FILTER().