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