View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default Advanced Filter Function

I am using the advanced filter function. Here is my criteria list:

Symbol
AMR
BA
BP

Here's is the result:

Symbol
BA
BA
BA
BA
BA
BA
BAC
BAC
BA
BA
BA
BA
BA
BA
AMR
BAC
BAC
AMR
BAC
BAC
BAC
BAC
BAX
BAX
BAC
BAC
BAC
BAC
BA
BAC
BAC
BA

Is there any way to have the filter result contain only the 3 symbols in the
criteria list ?

Thank you in advance.