advance filter
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
|