The If_empty argument is “” (quote quote), instructing Excel to leave the cell blank if nothing is returned in the filter. The finished formula entered into cell L2 is shown below. This formula ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.