I'm getting seriously mad...
I have this data table:
[TABLE="width: 1180"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Regular[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Unassigned[/TD]
[TD]APC low[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIN[/TD]
[TD]Matr[/TD]
[TD]Area[/TD]
[TD]Country[/TD]
[TD]Customer[/TD]
[TD]Vol[/TD]
[TD]APC[/TD]
[TD][/TD]
[TD]APC[/TD]
[TD]Customer[/TD]
[TD][/TD]
[TD]Customer[/TD]
[TD][/TD]
[TD]APC[/TD]
[TD]Customer[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Central East Europe[/TD]
[TD]Estonia[/TD]
[TD]257851[/TD]
[TD]25[/TD]
[TD]37,81[/TD]
[TD][/TD]
[TD]>5[/TD]
[TD]<>"#"[/TD]
[TD][/TD]
[TD]#[/TD]
[TD][/TD]
[TD]<=5[/TD]
[TD]<>"#"[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Italy[/TD]
[TD]Italy[/TD]
[TD]246892[/TD]
[TD]25[/TD]
[TD]30,80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Spain & Portugal[/TD]
[TD]Spain[/TD]
[TD]#[/TD]
[TD]25[/TD]
[TD]28,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Central East Europe[/TD]
[TD]Poland[/TD]
[TD]#[/TD]
[TD]25[/TD]
[TD]2,99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
...about 230 rows worth
If I use the Data, Advanced Filter to extract rows that have a defined customer and an APC above 5, that works well (The two criteria columns under "Regular")
If I try to extract just rows with an undefined customer (# instead of a number), that works well. (The criteria column under "Unassigned")
BUT - if I try to extract defined customers with a low APC, Excel invariably and whatever I do insists on returning the low APCs but ALSO the # customers. (two criteria columns under "APC low")
What????
Can anybody give me a hint as to why "<>#" works in one setting but not in another?
I have this data table:
[TABLE="width: 1180"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Regular[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Unassigned[/TD]
[TD]APC low[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIN[/TD]
[TD]Matr[/TD]
[TD]Area[/TD]
[TD]Country[/TD]
[TD]Customer[/TD]
[TD]Vol[/TD]
[TD]APC[/TD]
[TD][/TD]
[TD]APC[/TD]
[TD]Customer[/TD]
[TD][/TD]
[TD]Customer[/TD]
[TD][/TD]
[TD]APC[/TD]
[TD]Customer[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Central East Europe[/TD]
[TD]Estonia[/TD]
[TD]257851[/TD]
[TD]25[/TD]
[TD]37,81[/TD]
[TD][/TD]
[TD]>5[/TD]
[TD]<>"#"[/TD]
[TD][/TD]
[TD]#[/TD]
[TD][/TD]
[TD]<=5[/TD]
[TD]<>"#"[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Italy[/TD]
[TD]Italy[/TD]
[TD]246892[/TD]
[TD]25[/TD]
[TD]30,80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Spain & Portugal[/TD]
[TD]Spain[/TD]
[TD]#[/TD]
[TD]25[/TD]
[TD]28,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Product A[/TD]
[TD]Central East Europe[/TD]
[TD]Poland[/TD]
[TD]#[/TD]
[TD]25[/TD]
[TD]2,99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
...about 230 rows worth
If I use the Data, Advanced Filter to extract rows that have a defined customer and an APC above 5, that works well (The two criteria columns under "Regular")
If I try to extract just rows with an undefined customer (# instead of a number), that works well. (The criteria column under "Unassigned")
BUT - if I try to extract defined customers with a low APC, Excel invariably and whatever I do insists on returning the low APCs but ALSO the # customers. (two criteria columns under "APC low")
What????
Can anybody give me a hint as to why "<>#" works in one setting but not in another?