advance filter

  • Thread starter Thread starter Alberto Ast
  • Start date Start date
A

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?
 
AutoFilter>Custom> From Custom Filter window select 'equal to' and enter 'ABC'

If this post helps click Yes
 
Thanks you both but I am using advance filter... I just type into the cell
ABC but it select all cells starting with ABC
 
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"
 
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.)
 
Back
Top