Filter List Results Dependent on another Filter List

**Owlsfan** · 04-28-2013, 04:51 PM

Hi

I am hoping that someone could help me with the above as I am not too good with Excel.

What I want is to have a filter list display only the options that are applicable to the previous filter list option. I have 4 filter lists in total.

I have entered the data into named ranges and attached a test workbook which I hope explains what I need a little better.

Any help would be greatly appreciated.

Thank you

**oeldere** · 04-28-2013, 05:12 PM

for excel 2007 => data => filter (make a filter on row 1)

After that you can choose the filter on column D till I.

You can de-select the items you don't want to see.

**Owlsfan** · 04-28-2013, 06:20 PM

Hi Oeldere

Thank you for your response but although I know you can de-select the items not needed in the following filters the thing is I don't want the users to be given options that do not relate to them, only the options that do relate to their previous selection. This I am hoping will eliminate the number of wrong returns we receive.

By the way I am using 2010.

Once again thank you for your response.