Exclude Rows From Your Data Using a List - Google Sheets
/ @theworkflow_
This video will show you how to exclude rows of data by comparing against of list of items. It's like creating an left excluding join in SQL. Simply list the things you want to match on that you wish to not include in your table and let the formula do the work! No more hard coding filters to exclude information.
Sample Data Here: https://docs.google.com/spreadsheets/...
0:00 - Intro
0:14 - Explaining the set up
0:54 - The Formula
1:02 - Formula Breakdown
2:10 - Putting It All Together
2:54 - Scaling
3:20 - Get The Sheet