Advanced Search

  • Thread starter Thread starter Pellechi
  • Start date Start date
P

Pellechi

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
 
Back
Top