Advanced Filter

[Christine]

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?

 

[Pete_UK]

Don't you need to put Keppel and Tristar within quotes " " ?

And in your post you have an apostrophe after SM*

Hope this helps.

Pete

 

[John C]

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?

 

[Peo Sjoblom]

Works fine for me. What did not work for you?

Btw, you don't need the equal sign for Keppel, meaning you don't have to set
the criteria up like


="=Keppel"

or

="<>Tristar"



it works fine using

Keppel

<>Tristar


without the equal sign

--


Regards,


Peo Sjoblom