View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raul Raul is offline
external usenet poster
 
Posts: 86
Default Advanced Filter Criteria Problem

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