Texas Longhorn
Active Member
- Joined
- Sep 30, 2003
- Messages
- 493
I'm using advanced filter on a list, and I'm trying to use multiple "does not equals". Here's what I've got:
I'm not sure why this is failing to filter out DL and NA. When I enter just one criterion (e.g.<>DL), the filter works, but when I attempt multiple<>s, it does not.
What am I doing wrong?
Many thanks,
Bill
Book4 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Int'l | Reg | Country | Dir | Mgr | Rep | ||
2 | <>NA | |||||||
3 | <>DL | |||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | Dir | Mgr | Rep | |||||
8 | NXB | SLGR | GM | |||||
9 | NXB | NBC | GAL | |||||
10 | NXB | SLG | CLW | |||||
11 | DL | DL | MH | |||||
12 | DL | DL | GK | |||||
13 | PGO | KAC | SBA | |||||
14 | NXB | SLG | ERM | |||||
15 | NXB | SLG | JPB | |||||
16 | PGO | KAC | BMM | |||||
17 | DL | PM | JR | |||||
18 | MJM | MLW | DXS | |||||
19 | PMP | BLS | CMS | |||||
20 | MJM | JMM | JMK | |||||
21 | PMP | BLS | BPB | |||||
22 | DL | DL | AM | |||||
23 | NA | NA | DAS | |||||
24 | PMP | PAK | HRM | |||||
25 | PMP | DWB | DTT | |||||
26 | PMP | DWB | JPB | |||||
Sheet2 |
I'm not sure why this is failing to filter out DL and NA. When I enter just one criterion (e.g.<>DL), the filter works, but when I attempt multiple<>s, it does not.
What am I doing wrong?
Many thanks,
Bill