Google Sheets
=FILTER(...)Google Sheets FILTER with Optional Criteria: 3 Patterns
Build Google Sheets FILTER formulas with blank criteria, AND or OR logic, dropdowns, and no-match handling.
Explore ↗
#optional-criteria
1 formula guide
1 formula guide
=FILTER(...)Build Google Sheets FILTER formulas with blank criteria, AND or OR logic, dropdowns, and no-match handling.