Advance Filter Errors

[Guest]

When using Advanced Filters for Rail “Day Validity Profiles†(DVP) i.e. The
days of the week that a Train is Timetabled (shown below), I have asked for a
filter showing only certain DVPs... It is also showing others.

Example:
Data including all DVPs are filtered by only those that include Mondays (MO,
TX, WX, ThX, FX, MTO, MWO, MThO, MFO, TWX, TThX, MWX, TFX, WThX, WFX, ThFX).
The results (for no reason I can fathom) include “MXâ€.

Does anyone know if there are known issues with this, or if there are, if
there are known solutions?

Standard DVPs
MO Monday Only
TO Tuesday Only
WO Wednesday Only
ThO Thursday Only
FO Friday Only
MX Monday Excepted
TX Tuesday Excepted
WX Wednesday Excepted
ThX Thursday Excepted
FX Friday Excepted
MTO Monday and Tuesday Only
MWO Monday and Wednesday Only
MThO Monday and Thursday Only
MFO Monday and Friday Only
TWO Tuesday and Wednesday Only
TThO Tuesday and Thursday Only
TFO Tuesday and Friday Only
WThO Wednesday and Thursday Only
WFO Wednesday and Friday Only
ThFO Thursday and Friday Only
MTX Monday and Tuesday Excepted
MThX Monday and Thursday Excepted
MFX Monday and Friday Excepted
TWX Tuesday and Wednesday Excepted
TThX Tuesday and Thursday Excepted
MWX Monday and Wednesday Excepted
TFX Tuesday and Friday Excepted
WThX Wednesday and Thursday Excepted
WFX Wednesday and Friday Excepted
ThFX Thursday and Friday Excepted

 

[Guest]

Oops... I left out the important bits!

The below is edited.

 

[Guest]

Opps, I left out the important bits!

 

[Bob Umlas]

If I understand you correctly, the items containing MFX also have MO in it
(from "Monday" -- case insensitive), so it's showing up because of that. Or
perhaps I don't really follow!

 

[Debra Dalgleish]

What's in the criteria area for the advanced filter?

 

[Guest]

Though in answer to Bob's question, the word "Monday" does not appear (as
only the CODE is used), it struck me how that I was NOT telling to only look
in the right column... The kind of mistake we all make occationally (and then
kick ourselves).

Thank you both for looking at this for me anyway.

Gnomie

 

[Guest]

OK, I know I'm being stupid now...

Right, the problem is REALY simple.
When you use normal filtering, you can say show me "MF" & "FX" only, and
that is what is gives... In Advanced (where I can then give a long list (as
shown), if I want any "Monday" then amongst the codes I will need to include
"MF" (which means Monday to Friday iclusive), the results it gives will also
include "MFX" (which means Monday & Friday EXCEPTED). This is clearly
because the Advanced Filter does not look at "Entire Cell".

Is there a way to tell Advanced Filter to only include the whole cell
content (ie if you say "MF" it will not give "MFX" as a result?

 

[Debra Dalgleish]

In the criteria cell, enter: ="=MF"

OK, I know I'm being stupid now...

Right, the problem is REALY simple.
When you use normal filtering, you can say show me "MF" & "FX" only, and
that is what is gives... In Advanced (where I can then give a long list (as
shown), if I want any "Monday" then amongst the codes I will need to include
"MF" (which means Monday to Friday iclusive), the results it gives will also
include "MFX" (which means Monday & Friday EXCEPTED). This is clearly
because the Advanced Filter does not look at "Entire Cell".

Is there a way to tell Advanced Filter to only include the whole cell
content (ie if you say "MF" it will not give "MFX" as a result?

:

 

[Guest]

Thanks Debra.

How stupid do I feel?

Gnomie

In the criteria cell, enter: ="=MF"