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.)

Dave Peterson wrote:

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"

Alberto Ast wrote:

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?

--

Dave Peterson

--

Dave Peterson