You could use this for your criteria for an adv. filter:

=ISERROR(SEARCH("apple",A2))*ISERROR(SEARCH("orang e",A2))

where you want to exclude anything in col. A containing "orange" and "apple."

To learn more, see:

http://www.contextures.com/xladvfilter01.html

HTH
Jason
Atlanta, GA


"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.