Advanced Filter not pulling exact matches

  • Thread starter Thread starter duketter
  • Start date Start date
D

duketter

Excel 2007 - I am performing an advanced filter where I only want an entire
listing filter by specific criteria. When I perform the advanced filter it
is not pulling exact matches, it will pull the following (abcd & abcd1) even
though in my advanced filter criteria I have only abcd. How can I get it to
pull only the exact match? Here is another example. The first item is my
spreadsheet listing. The second is my advanced filter criteria.

Name
abcd
abcd1
fred
sam
sam2
frank
joe
jon

name
abcd
sam

When i do an advanced filter with the abcd and sam criteria I get:
Name
abcd
abcd1
sam
sam2

When I should only get. I don't want the names that end in 2 or are similar.
Name
abcd
sam
 
Saved from a previous post:

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

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

Or use a formula that evaluates to that same text string.
="="&"ED"
 
Back
Top