Filtering data and selecting from a list

[daveb9]

I have a number of products which I would like to select from within Excel the product have features and I would like to be able to use a list box to allow me to select the product I require

For example

Product feature1 feature2 feature3 feature4
XY1 y n y y
XY2 n y n y
XY3 y y y n
XY4 n n n n

lets say I would like to select a component with feature4 I would like to have a selection list box with the options XY1 and XY2 only returned, any help would be greatly appreciated.


Dave

 

[FrenchCAD]

Data > Filters... (or whatever the name next to Tools in the english version)

It should allow you to make it

Cyril Guichard
Mechanical Engineer