Thread: Excel - how do I use drop down list to filter data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna Donna is offline
external usenet poster
  
Posts: 180
Default Excel - how do I use drop down list to filter data
How can I use pull down lists to filter data. For instance I have a
spreadsheet of 100 different cars of various makes/models. I want to use
the first pull down menu to filter out all of the Chevrolets. The next pull
down will show the results of the first pull down. where I can select one.
Is this possible?

Reply With QuoteReply With Quote