Opv
05-25-2011, 09:08 AM
I am attempting to apply an AutoFilter to a column containing categories for each row in a worksheet. My problem is that the category column may include one, two, three or more categories. Multiple categories are separated by a comma, i.e., "Email, Work, Military" etc. Thus when I attempt to filter on "Email" Excel is not finding those rows in which Email is one of multiple assigned categories.
Is there a way to combine Instr with the AutoFilter Criteria so that I can include all applicable rows in the filter?
Is there a way to combine Instr with the AutoFilter Criteria so that I can include all applicable rows in the filter?