You will need another set of cells that are your criteria. The first row in
the criteria must be the column headers from the main data table (the 'list
range') which will be used to filter. Ex: if your list range column
headers are Date, Sales and Weekday and you're going to filter on Weekday,
the criteria range must have Weekday (at least) in the first row. Each
subsequent row of the criteria range is one filter criteria; the result is
the union of all the filters (filter1 OR filter2 OR filter3 would be the
autofilter analogy). If you wanted to see the sales only on Monday, Tuesday
and Wednesday, for instance, the next three rows in your criteria range would
be 2, 3, 4.
Then select your data table and Data Filter Advanced Filter. Specify
the list range (Excel will fill this in for you if you selected the table
before turning on the filter) and the criteria range (the set of cells
including the headers on the criteria) and click OK.

"util" wrote:

How do I set up advance filters excel 2003 using one column with mutlitple
entries. Auto filter allows only two entries and the numeric range varies.

Please advise.