Filtering - use drop downs with set ranges, or text boxes for arbitrary values

1. How do I filter a drop-down list in Excel based on cell value?

How do I filter a drop-down list in Excel based on cell value?

In the same or in another spreadsheet, select a cell or several cells in which you want your primary drop-down list to appear. Go to the Data tab, click Data Validation and set up a drop-down list based on a named range in the usual way by selecting List under Allow and entering the range name in the Source box.