View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
duketter duketter is offline
external usenet poster
 
Posts: 63
Default Advanced Filter not pulling exact matches

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