Try something like this to use Advanced Filter:

If the filter field is "CustName", and you want to filter customers that
contain "inc" or "comp" or "LTD"......

Copy the CustName field name of to the side of the data
Assuming you paste it into cell F1:
F1: Custname
F2: *inc*
F3: *comp*
F4: *LTD*
(The asterisks are wildcards that match any text)

Next, select your data range
Data|Filter|Advanced Filter
List range: (your already selected data)
Criteria range: $F$1:$F$4
Click the [OK] button to filter the list in place

That will hide any rows where the CustName field does NOT contain the listed
criteria.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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