Advanced Filter not pulling exact matches

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
 
D

Dave Peterson

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top