I am running a college football pool and I want to get a list of all of the teams that are playing in the games this year. I want to return the names of the teams in column K & M, in one column (separate schedule) if Column C is "2022". Is there a way to use the filter to pull from both columns?
So on my work computer it won't allow me to install the Mini-Sheet however here is the sheet:
So on my work computer it won't allow me to install the Mini-Sheet however here is the sheet:
C | D | E | F | G | H | I | J | K | L | M |
Year | Playoff/ Champ | Bowl | Location | Date | Time | Network | Fave Rank | Favorite | Dog Rank | Underdog |
2022 | Bahamas | Nassau, Bahamas | 12/16/2022 | 11:30 AM | ESPN | UAB | Miami (Ohio) | |||
2022 | Cure | Orlando, FL | 12/16/2022 | 3:00 PM | ESPN | 24 | Troy | 25 | UTSA | |
2022 | Fenway | Boston, MA | 12/17/2022 | 11:00 AM | ESPN | Louisville | Cincinnati | |||
2022 | Celebration | Atlanta, GA | 12/17/2022 | 12:00 PM | ABC | Jackson State | NC Central | |||
2022 | New Mexico | Albuquerque, NM | 12/17/2022 | 2:15 PM | ESPN | SMU | BYU | |||
2022 | Jimmy Kimmel | Los Angeles, CA | 12/17/2022 | 3:30 PM | ABC | Fresno State | Washington State | |||
2022 | Lending Tree | Mobile, AL | 12/17/2022 | 5:45 PM | ESPN | Southern Miss | Rice | |||
2022 | Las Vegas | Las Vegas, NV | 12/17/2022 | 7:30 PM | ESPN | 14 | Oregon State | Florida | ||
2022 | Frisco | Frisco, TX | 12/17/2022 | 9:15 PM | ESPN | Boise State | North Texas | |||
2022 | Myrtle Beach | Conway, SC | 12/19/2022 | 2:30 PM | ESPN | Marshall | Connecticut | |||
2022 | Famous Idaho Potato | Boise, ID | 12/20/2022 | 3:30 PM | ESPN | San Jose State | Eastern Michigan | |||
2022 | Boca Raton | Boca Raton, FL | 12/20/2022 | 7:30 PM | ESPN | Toledo | Liberty | |||
2022 | New Orleans | New Orleans, LA | 12/21/2022 | 9:00 PM | ESPN | South Alabama | Western Kentucky | |||
2022 | Armed Forces | Fort Worth, TX | 12/22/2022 | 7:30 PM | ESPN | Baylor | Air Force |