Thread: Advanced Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christine[_3_] Christine[_3_] is offline
external usenet poster
 
Posts: 11
Default Advanced Filter

My filter criteria is:

Warehouse is Keppel
Customer is not Tristar
Invoice numbers do not begin with 'SA' or 'SM'

This is what I did at the filter criteria range:

Warehouse Customer Inv No Inv No
=Keppel <Tristar <"SA*" <"SM*'


It didn't work the way I want. What's wrong?