Advanced filter using multiple criteria

**logan131131** · 07-15-2012, 09:30 PM

Hi,

I have been struggling with this for over a day, any help would be much appreciated.
I need to run an auto filter to filter my worksheet based on some criteria.

Each line is tagged by comma separated values entered into a single cell in the corresponding row.
I need to be able to filter the line based on each comma separated value in the cell.
The criteria for filtering is entered into a separate cell.

- logan

**martindwilson** · 07-15-2012, 09:51 PM

post a sample but generally it is much much better to have separate cells! buy you can use wild cards if your data is suitable for it or a formula to pin it down
see both ways attached

**logan131131** · 07-16-2012, 10:41 AM

Thanks I have attached the file. I can assign the tags under the "Tags" header in the drop down menu for each question.
Here's what i have to do.
I need to be able to filter the question out based on the specified tag/tags.
I am mentioning the specified tags under column X1 (row wise) in the TagAssignment worksheet.
If the specified tag is say "Services", I need to be able to pull up the questions that contains the assigned tag "Services". (in this case questions 1,2 and 5.
And I need to be able to iterate over all the specified tags.
Module2 currently does the filtering but only for one case. I would like to iterate and filter.

Thanks in advance.
Logan

**martindwilson** · 07-16-2012, 11:11 AM

thats got nothing to do with auto filter!

**logan131131** · 07-16-2012, 11:36 AM

Sorry if I didn't make myself clear, the auto filtering here is basically filtering the questions based on every tag entered under the column X.
For instance if I have "Services" and "Other" entered in column X, the filter needs to return questions 1,2,3 and 5.
This works for one tag,(module2) but i need this to iterate over all the tags specified in column X.