How To Filter Spreadsheet Data

How to Filter Data in Google Sheets: FILTER Function vs Create a Filter & Filter Views This tutorial shows two ways to filter data in Google Sheets. First, it demonstrates using the FILTER function on a separate sheet to create a safe, read-only view of a master data tab by filtering a range (e.g., Sheet1!A:E) with conditions such as a specific month in a column and a percentage greater than 4% (0.04), handling no-results errors by wrapping the formula in IFNA, and making the month dynamic with a dropdown and a cell reference. Second, it demonstrates the built-in Create a filter tool, including how to turn it on, use header filter menus to show only values like January, edit filtered rows, and remove the filter while keeping edits. It also explains updated behavior of filters and filter views, including saving named filter views and that only the user sees their filter view. 00:00 Filtering Overview 00:24 Filter Function Views 01:13 Multiple Conditions 01:28 No Matches Handling 01:43 Dropdown Month Selector 02:09 Create a Filter Tool 03:06 Editing Filtered Data 03:23 Filter Views Updates 03:49 Saving Filter Views 04:19 Wrap Up and Subscribe