dimanche 10 juillet 2016

selective filtering so that select rows only if cell A or cell B contains a value

I have a dataset that contains baseball record, I want to pick only one team to look at, so is there anyway I can apply filter on HomeTeam and VisitTeam so that if either HomeTeam or VisitTeam contains the team name, say PHI, the who row stays?

E.g: I have the data

HomeTeam VisitTeam
PHI      CLE
ATL      NYC
DET      PHI

I want the first row and third row.

Thank you!

Aucun commentaire:

Enregistrer un commentaire