Hey I have data like this:
[TABLE="width: 199"]
<tbody>[TR]
[TD]HomeTeam[/TD]
[TD]AwayTeam[/TD]
[/TR]
[TR]
[TD]Arsenal[/TD]
[TD]Aston Villa[/TD]
[/TR]
[TR]
[TD]Liverpool[/TD]
[TD]Stoke[/TD]
[/TR]
[TR]
[TD]Norwich[/TD]
[TD]Everton[/TD]
[/TR]
[TR]
[TD]Sunderland[/TD]
[TD]Fulham[/TD]
[/TR]
[TR]
[TD]Swansea[/TD]
[TD]Man United[/TD]
[/TR]
[TR]
[TD]West Brom[/TD]
[TD]Southampton[/TD]
[/TR]
[TR]
[TD]West Ham[/TD]
[TD]Cardiff[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Hull[/TD]
[/TR]
[TR]
[TD]Crystal Palace[/TD]
[TD]Tottenham[/TD]
[/TR]
[TR]
[TD]Man City[/TD]
[TD]Newcastle[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Aston Villa[/TD]
[/TR]
[TR]
[TD]Aston Villa[/TD]
[TD]Liverpool[/TD]
[/TR]
[TR]
[TD]Everton[/TD]
[TD]West Brom[/TD]
[/TR]
[TR]
[TD]Fulham[/TD]
[TD]Arsenal[/TD]
[/TR]
[TR]
[TD]Hull[/TD]
[TD]Norwich[/TD]
[/TR]
[TR]
[TD]Newcastle[/TD]
[TD]West Ham[/TD]
[/TR]
[TR]
[TD]Southampton[/TD]
[TD]Sunderland[/TD]
[/TR]
[TR]
[TD]Stoke[/TD]
[TD]Crystal Palace[/TD]
[/TR]
[TR]
[TD]Cardiff[/TD]
[TD]Man City[/TD]
[/TR]
[TR]
[TD]Tottenham[/TD]
[TD]Swansea[/TD]
[/TR]
[TR]
[TD]Man United[/TD]
[TD]Chelsea[/TD]
[/TR]
[TR]
[TD]Cardiff[/TD]
[TD]Everton[/TD]
[/TR]
</tbody>[/TABLE]
I am trying to sort or filter the list so that I have a list that contains all matches where for eksampel Arsenal is EITHER a home team OR an away team. But this seems to be a contraditory condition when I filter, because when I isolate Arsenal as a Home Team I cannot also filter it so they are the away team...... Any thoughts on this issue...?
[TABLE="width: 199"]
<tbody>[TR]
[TD]HomeTeam[/TD]
[TD]AwayTeam[/TD]
[/TR]
[TR]
[TD]Arsenal[/TD]
[TD]Aston Villa[/TD]
[/TR]
[TR]
[TD]Liverpool[/TD]
[TD]Stoke[/TD]
[/TR]
[TR]
[TD]Norwich[/TD]
[TD]Everton[/TD]
[/TR]
[TR]
[TD]Sunderland[/TD]
[TD]Fulham[/TD]
[/TR]
[TR]
[TD]Swansea[/TD]
[TD]Man United[/TD]
[/TR]
[TR]
[TD]West Brom[/TD]
[TD]Southampton[/TD]
[/TR]
[TR]
[TD]West Ham[/TD]
[TD]Cardiff[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Hull[/TD]
[/TR]
[TR]
[TD]Crystal Palace[/TD]
[TD]Tottenham[/TD]
[/TR]
[TR]
[TD]Man City[/TD]
[TD]Newcastle[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Aston Villa[/TD]
[/TR]
[TR]
[TD]Aston Villa[/TD]
[TD]Liverpool[/TD]
[/TR]
[TR]
[TD]Everton[/TD]
[TD]West Brom[/TD]
[/TR]
[TR]
[TD]Fulham[/TD]
[TD]Arsenal[/TD]
[/TR]
[TR]
[TD]Hull[/TD]
[TD]Norwich[/TD]
[/TR]
[TR]
[TD]Newcastle[/TD]
[TD]West Ham[/TD]
[/TR]
[TR]
[TD]Southampton[/TD]
[TD]Sunderland[/TD]
[/TR]
[TR]
[TD]Stoke[/TD]
[TD]Crystal Palace[/TD]
[/TR]
[TR]
[TD]Cardiff[/TD]
[TD]Man City[/TD]
[/TR]
[TR]
[TD]Tottenham[/TD]
[TD]Swansea[/TD]
[/TR]
[TR]
[TD]Man United[/TD]
[TD]Chelsea[/TD]
[/TR]
[TR]
[TD]Cardiff[/TD]
[TD]Everton[/TD]
[/TR]
</tbody>[/TABLE]
I am trying to sort or filter the list so that I have a list that contains all matches where for eksampel Arsenal is EITHER a home team OR an away team. But this seems to be a contraditory condition when I filter, because when I isolate Arsenal as a Home Team I cannot also filter it so they are the away team...... Any thoughts on this issue...?