To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

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

NOTE: For complex queries with multiple filters, use a Relational database spreadsheet and create Pivot Table reports. Excel formulas and functions: Our best tips ...

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.