Hi Dave,

this page looks pretty nice. I will add it to my favorites.

Alex

"Dave Peterson" wrote:

Debra Dalgleish has some notes:
http://contextures.com/xladvfilter01.html

For me, I like to cheat.

I use a helper column and build a formula (as complex as I need) that returns
true or false. Then I filter on that column.

Alex wrote:

I want to filter a table with at least 5 "does contain" criteria.

However this is not possible with the "Auto Filter" and I couldn't figure
out how the "advanced filtering" worked.

Can anybody give me some ideas?

Thanks,

Alex

--

Dave Peterson