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.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

The array argument represents the range of data you want to filter, while the include argument specifies the criteria for filtering. The optional if_empty argument allows you to display a custom ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.