Progressive Filtering

Doc203

New Member
Joined
Jan 23, 2011
Messages
32
I am working in a rather large Vehicle database with 44k rows. It looks something like:

Year-----Make-----Model-----Weight
1972----Chevy----Impala-----3800
2005----Chevy----Impala-----2900
1972----Ford-------F150-----4000
1997----Chevy----Impala-----3800


What I want to do is a combo box with a data validation list that the user chooses in order, which progressively shrinks the next choice.

IE - If you choose year 1972, it narrows the choices of the "Make" Column (Similar to auto filter). You then choose the Make column, which in turn shortens the model list. Then when you finally choose a model, which would be the final choice.

After choosing the model, the weight is the final product.

Any ideas?

Thanks,

Jim
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Doc203

New Member
Joined
Jan 23, 2011
Messages
32
Also, there are several duplicate instances of "year" and when I use data validation, I would like to only reveal one instance of each year for the user to pick from.
 
Last edited:

Forum statistics

Threads
1,141,019
Messages
5,703,771
Members
421,315
Latest member
awaisnazir139

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top