Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
Advanced Excel Drop down List | Excel Discussion (Misc queries) | |||
How do I tie prices to a drop down list of products in excel? | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) |