Hello, I have built an excel doc (and google sheet) with football schedules for 80 high schools. There is a separate column for VISITING team and one for HOME team. How can I set up a filter or sort so that it shows (or extracts to another sheet) the away AND home games for one team, showing the entire row of each entry so we know the opponent, game time, conference status, etc. For instance Date ^t Visitor ^t Home ^t Time ^t Conference 9/1 ^t Polk High ^t East Side ^t 7 p.m. ^t Citywide 9/8 ^t West Side ^t Polk High ^t 7 p.m. ^t Non-conference I'd like to do this for each of the 80 teams or so that are mentioned on the schedule. Thanks!
Solved by I. S. in 26 mins