Filter with Data Validation in Google Sheets
Filter function with criteria for data validation in Google Sheets. Text filter with criteria in a Google Spreadsheet drop-down list. Selecting an option in the Google Spreadsheet drop-down list automatically filters text records using the filter function.