View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Burghthing
 
Posts: n/a
Default How do I Auto-Filter with multiple values in a cell in Excel?

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