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.

[TABLE="width: 115"]
<colgroup><col></colgroup><tbody>[TR]
[TABLE="width: 243"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Names
[/TD]
[TD] [/TD]
[TD]Names[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD] [/TD]
[TD]John
[/TD]
[/TR]
[TR]
[TD]Emma
[/TD]
[TD] [/TD]
[TD]Tom
[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tom
[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Donald[/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]John Archer[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TR]
[TR]

[/TR]
[TR]

[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]

[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 115"]
<tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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!