Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |