Master the FILTER formula in Google Sheets!
The FILTER formula blows standard filtering out of the water. It's simple to understand and will instantly allow you to slice your data into various ways. Using this strategically can help you create beautiful dashboards, organize your spreadsheet, and save a ton of time trying to vet data.
FILTER is powerful on it's own but it's even more powerful when it's coupled with other formulas. You'll see a few examples in this video!
00:00 - Intro
00:36 - Filter out blank cells
02:02 - Filter by Conditions
02:43 - Only include specific columns
03:21 - Sort Filtered Data
04:02 - Use Dynamic Filters]
07:05 - Allow for Blank Conditions
07:59 - Compare lists to find missing values
10:23 - Limit results with ARRAY_CONSTRAIN
12:39 - Outro