View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Haughs Graham Haughs is offline
external usenet poster
 
Posts: 7
Default Advanced filter with *

I have a database where one of the records is made up of some notes. Once
the notes have been processed an * is put at the start of the first letter
of the first sentence to show that it has been dealt with. All I want to do
is select out all the records which do not have an * in that particular
record. I appreciate it is a wildcard character, and I understand it would
be simpler to create another Y/N record but the circumstances do not allow
that in this situation so I would be grateful if anyone could advise me if
there is there any way to set the criteria to allow this selection.

Kind regards
Graham Haughs