Hello,

I'm familiar with Advanced Filter, however I'm having difficulty applying a
filter where I want to exclude any row that contains the value 100 in column
C, AND contains the word "roll" in column E.

The criteria I'm using are currently;
Line item seq Description
<100 <*roll*

However, using this criteria, excel is removing any row that contains 100 in
column C, OR the word "roll" in Column E.

I'm sure there's a way to set this up properly, but I'm puzzled.
Thanks,
Mark