Advanced filter issue

[naderfikry]

Hi all,

I've been using advanced filter with criteria range for quite long now but lately I noticed something which I am not sure if it's a bug or not.

Please check the example belowe, I have the 1st column which I need to filter (column on the left) and the criteria range column (column on the right).

Now after filtering I expect to get the filtered result showing "John" and "Tom" only; however "John Archer" comes out as well which produces inaccurate results for me specially when I work on large data sheets. Was it always like this or is this new? Or is it a bug?

Thanks.

<colgroup><col></colgroup><tbody>

Names		Names
John		John
Emma		Tom
Mary
Tom
Donald
John Archer

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

</tbody>

<tbody>
</tbody>

 

[RoryA]

By default, advanced filter uses a 'begins with' text filter. So if you just enter John, it will match any rows that start with John. If you want an exact match, enter:
'=John
in the criteria cell.

 

[naderfikry]

By default, advanced filter uses a 'begins with' text filter. So if you just enter John, it will match any rows that start with John. If you want an exact match, enter:
'=John
in the criteria cell.

Oh, Thank you very much Rory. Great tip!

 

[RoryA]

Glad to help, and welcome to the forum!