What didn't work? More info needed. i.e.: what got through the filter that
shouldn't have been, or, what got filtered out that shouldn't have been?
--
** John C **

"Christine" wrote:

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?