How do I Auto-Filter with multiple values in a cell in Excel?

[Guest]

Is it possible to use the Auto-Filter in Excel 2003 in the following way:

Cell Value: Requirements, Testing
Cell Value: Requirements
Cell Value: Testing

Is there a way I can enter my cell value such that the Auto-Filter values
will only show "Requirements" and "Testing" in the dropdown, but not
"Requirements, Testing"? I've tried using ; , | and even hard returns as
separators, but to no avail.

Am I asking too much of the auto-filter?

Thanks in advance

 

[Guest]

Unless you create another column to indicate the match, I think you are
asking too much of the autofilter. Check the advanced filter instead.
You'll have to set up 'criteria', a group of cells separate from your data,
and you would have a row in the criteria for each criterion. So you'd have a
three-row criteria: the header, then 'Requirements', then 'Testing.'

 

[Guest]

I was afraid that was going to be the response. Thanks bpeltzer!