Filter Your Data Automatically Using Another Data Set - Google Sheets
This video will show you how to filter your data by comparing against a list of items. It's like creating an inner join in SQL. Simply list the things you want to include in your table and let the formula do the work! No more hard coding filters to include certain rows.
Sample Data Here: https://docs.google.com/spreadsheets/...
0:00 - Intro
0:10 - Explaining the set up
0:55 - The Formula
1:40 - Formula Breakdown
2:41 - Putting It All Together
3:06 - Scaling
3:20 - Get The Sheet