Excel - how do I use drop down list to filter data

D

Donna

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?
 
M

Max

Donna said:
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?
Click to expand...

Assume the car make descriptions are housed in col B,
label in B1, data from row2 down

Select the entire table, then
Click Data > Filter > Autofilter
Select "Custom" from the autofilter dropdown list in B1
Under "Show rows where",
Select "contains", then type in the box next to it: Chevrolet
Click OK
 
D

Donna

Max,

Thank you. How do I then use that pull down to limit the number of entries
in the 2nd pulldown to limit it to "Camaro's?
 
R

Roger Govier

Hi Donna

Repeat the procedure Max gave you, but on the column containing the
Model type e.g. supposing Model is in column C then use the dropdown on
column C, select Custom>Contains> and type Camaro in the white pane
 
Top