Filtering out results

[Cat]

Just wondering if there is any way of applying a filter/query to remove
certain segments.
E.g. filter out everyone called Jones in a list so that all other names are
left on the sheet except Jones

Thanx in advance,
Cat

 

[Allen Browne]

Set the Criteria under this field to:
Is Null OR <> "Jones"