To All,

My current advanced search table works fine ...

'current ADVANCED filter table

SHIFT CODE
6T D
7T D
8T D
6 D
7 D
8 D

QUESTION:
I want to modify the filter so the code can be EITHER a "D" or an "A" ?

How do I set up the table so the advanced filter will flag all SHIFTS "6T"
that has a CODE of "D" OR "A" ???

Any help would be appreciated ....

Use a 3 row, 2 column criteria range:
Shift Code
6T D
6T A

Same row is logical AND
Different row is logical OR

Regards,
Tom Ogilvy

"Pellechi" wrote in message
.net...
To All,

My current advanced search table works fine ...

'current ADVANCED filter table

SHIFT CODE
6T D
7T D
8T D
6 D
7 D
8 D

QUESTION:
I want to modify the filter so the code can be EITHER a "D" or an "A" ?

How do I set up the table so the advanced filter will flag all SHIFTS "6T"
that has a CODE of "D" OR "A" ???

Any help would be appreciated ....