Multiples Filters

[toguko]

Hello, I searched the entire forum the answer to my question but unfortunately this did not find it.

I want to filter three columns and the fourth column appears only items relating to previous filters, will have to do this?

I know there must be many ways to do this, formulas, macros, but can not find a way to do it, is attached example worksheet.

 

[vrunda]

Exactly what should be the answer when u apply filter in col A, B, & C

 

[toguko]

Oh sorry, when apply the filters A, B, C in the column EQUIPMENT that only appears the equipaments linked of filters

example: When you filter Column A = AL; Column B = AIR and Column C = AIR. Only appears these equipaments: ALAIR__EHI303; ALAIR__EHI304; ALAIR__EHI305; ALAIR__EHI306, in column D

 

[Deepak]

You might looking for something like this....

http://chandoo.org/forum/threads/challenge-product-selection-tool.12567/#post-73653

 

[toguko]

Thank you, dEEPAK, checking the link now...

 

[toguko]

dEEPAK, The last link of the post you sent contains a worksheet that helped me a bit ...
But it was shown how to make only two columns, now I'm struggling to learn how to expand the selection of filters for a total of 4 columns.

Is attached the example spreadsheet I got the link and what I'm trying to do ...

 

[Deepak]

This might get rid of the trouble ......

 

[toguko]

THANK YOU

 

[toguko]

I am analyzing the code now to see if I understand.
But it served me perfectly, I'll just adapt to the worksheet that I am using.

thank you again