Excel 2003: Autofilter with Multiple Entries
 

I have a worksheet that has an autofilter on one of the columns. This column
contains names, so the filter sorts on the name. Well, one of the items has
two names instead of one and it is coming up in the filter as a separate
entry. How can I do this so that the autofilter filters on each of the two
names separately. (These are tasks with the names of people responsible for
the tasks and I don't want a task to be missed.)

Excel 2003: Autofilter with Multiple Entries
 

Hi,

Refer to "Filter by using advanced criteria " in the on-line help. This
gives you more control over the search criteria.

Challa Prabhu

"oceanmist" wrote:

I have a worksheet that has an autofilter on one of the columns. This column
contains names, so the filter sorts on the name. Well, one of the items has
two names instead of one and it is coming up in the filter as a separate
entry. How can I do this so that the autofilter filters on each of the two
names separately. (These are tasks with the names of people responsible for
the tasks and I don't want a task to be missed.)