I'm trying to use an advanced filter to eliminate don't care rows from
a large data set and the filter is not behaving as I expect.

My dataset has 22203 rows plus a header row, I', reduced the data to
just the one column that I need to filter on.

My criteria set set is 155 rows plus an identical header row, again
only one column.

In all of my tests I have selected all 22204 row for the source data,
and I'm filtering in place (ultimately I will want to filter to a
different destination.) Also all of my filter criteria are of the
form:

<*term1*
<*term2* and so on

For the criteria I first selected just the header row and the first
criteria item and the correct number of rows were filter out, all is
good so far.

Then I undo this filter and select for the criteria range the header
and the first two rows. This time the filter result contains more rows
than the first test, and the result should be a smaller set.

Then I undo the previous result and I select for the filter range the
header row and the first three rows and this time there are no rows
filtered from the source, I am left with the original set.

I must be doing something wrong but I can't see it. Any suggestions?

Thanks


John Keith