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?

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

"Donna" wrote:
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?

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

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?

"Max" wrote:

"Donna" wrote:
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?

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

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 CustomContains and type Camaro in the white pane

--
Regards

Roger Govier


"Donna" wrote in message
...
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?

"Max" wrote:

"Donna" wrote:
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?

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---