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