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 ().

and pipes. I managed to find several basic examples along with very cryptic documentation but overall didn’t find it very useful. After a bit of effort I managed to sort of figure it out and was able ...