advance filter

[Alberto Ast]

I have a table with advance filters... in one of the column I have different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

 

[Don Guillett]

data>filter>custom>equal to abc

 

[Jacob Skaria]

AutoFilter>Custom> From Custom Filter window select 'equal to' and enter 'ABC'

If this post helps click Yes

 

[Alberto Ast]

Thanks you both but I am using advance filter... I just type into the cell
ABC but it select all cells starting with ABC

 

[Herbert Seidenberg]

Excel 2007
Advanced Filter
Alberto: You are quite right, typing =ABC won't do.
Here is the right way:
http://www.mediafire.com/file/madyk3cmznz/10_09_09a.xlsx

 

[Dave Peterson]

Enter this as text (preform the cell as text or start with an apostrophe):

'=ABC
(to retrieve all the Ed's, but not the Eddie's.)

Or use a formula that evaluates to that same text string.
="="&"ABC"
or
="=ABC"

 

[Dave Peterson]

I saved this from a previous post, but forgot to change this line:
(to retrieve all the Ed's, but not the Eddie's.)
to
(to retrieve all the ABC's, but not the ABCDEF's.)