Filter two columns looking for like data

[flyers2thecup]

Hello All!

I did a search and couldn't find a post that matched what i'm trying to accomplish.

If i have a master team schedule...showing AWAY games in column G, and HOME games in column H, i want to be able to filter and see the teams ENTIRE schedule. right now i am filtering home, then filtering away and having to look at them separately.

Thank you, as always!!

 

[flyers2thecup]

This is the first time i asked a question and stumped you guys!

 

[Jonmo1]

Each filter can only look at the criteria within it's own column..
So filtering column G will hide the non home games in column G. But coincidentally also hides home games in H.

You'll need a helper column to test if either is true, then filter on that column.
So in say column I, you would use
=OR(G2="MyTeam",H2="MyTeam")

Then filter for TRUE on column I.

 

[flyers2thecup]

Perfect!! Thank you!!

 

[Jonmo1]

You're welcome.