if you set up a dummy column next to the one of interest, you can use if
stements to set up a yes or know criteria for what you want to include and
filter on thatr column with auto filter

for the advanced filter, My best suggestion is to read the help on it or
other books on it and play with it some. It is not really a response level
description on how to use it.

One of the other responders may have some good website recommendations?

"Raph_baril" wrote:

When using the autofilter you can use the custome filter and use the "does
not contain" criteria. However, I have multiple data I wish to not include
so I use the advance filter but I don't know how.