Advanced Filter Criteria Problem

[Guest]

I having a little problem with the output from a routine using the advanced
filter. The criteria range is specified as B2:B3 and the values in the
criteria range can be:

Name or Name
ABC A-2

The names can be ABC, ABC-BB, A-2, A-3, B-3, BBB, etc.

The problem is I'm getting the the values for ABC and ABC-BB when the
specified criteria is ABC. If the specified criteria is ABC-BB I get the
values for ABC-BB only; which is what I want. ABC-BB is the only name that
has three letters preceeding a hyphen.

Can anyone tell me what I'm missing, or need to add to the criteria?

Thanks,
Raul

 

[Tom Ogilvy]

Your criteria should be entered as

="=ABC"

rather than just ABC

 

[Guest]

Thanks,
Raul

Your criteria should be entered as

="=ABC"

rather than just ABC