Debra Dalgleish has some tips on using Advanced Filter he

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

Hope this helps.

Pete

On May 2, 3:50 pm, wrote:
I would like to use advanced filters (or something similar) to
essentially do this:

Here are my 100 criteria, display every row that
contains one of them in the spreadsheet.

Currently all I know how to do is:

Here are my 100 criteria, display every instance of them
in a specific column

and repeat that for every single column, which with 200
columns makes for a very nasty advanced filter

Thanks in advance!

--Chris