Adding a 3rd criteria to a filter.

As you can see below i have 2 criteria for excluding for a new list. Oddly when i add a 3rd criteria to the FIELD:=2 it errors.

Please Login or Register  to view this content.

You can only Autofilter more than 2 values if the are an exact match.
Either look at using an Advanced filter, or put a formula in a spare column that returns (for example) true or false & filter on that.

You could use this formula to filter on
=AND(OR(Y2={"Kit Component","Live Product","Replacement Part"}),C2<>"FP", SUM(COUNTIF(B2,{"wf*","cush*"}))=0)