I'm trying to setup a roster. In Cell K1 I have the date (which changes through drop down box). In column A I have a list of dates which some are the same date, Column C has Team 1 and Column E has Team 2
What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in Cell K2 and Team 2 in Cell L2.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in Cell K2 and Team 2 in Cell L2.
Tue, Oct 22, 2019 | 8:00p | New Orleans Pelicans | Toronto Raptors | |
Tue, Oct 22, 2019 | 10:30p | Los Angeles Lakers | Los Angeles Clippers | |
Wed, Oct 23, 2019 | 7:00p | Cleveland Cavaliers | Orlando Magic | |
Wed, Oct 23, 2019 | 7:00p | Detroit Pistons | Indiana Pacers | |
Wed, Oct 23, 2019 | 7:00p | Chicago Bulls | Charlotte Hornets | |
Wed, Oct 23, 2019 | 7:30p | Memphis Grizzlies | Miami Heat | |
Wed, Oct 23, 2019 | 7:30p | Minnesota Timberwolves | Brooklyn Nets | |
Wed, Oct 23, 2019 | 7:30p | Boston Celtics | Philadelphia 76ers | |
Wed, Oct 23, 2019 | 8:30p | Washington Wizards | Dallas Mavericks | |
Wed, Oct 23, 2019 | 8:30p | New York Knicks | San Antonio Spurs | |
Wed, Oct 23, 2019 | 9:00p | Oklahoma City Thunder | Utah Jazz | |
Wed, Oct 23, 2019 | 10:00p | Denver Nuggets | Portland Trail Blazers | |
Wed, Oct 23, 2019 | 10:00p | Sacramento Kings | Phoenix Suns | |
Thu, Oct 24, 2019 | 7:00p | Atlanta Hawks | Detroit Pistons | |
Thu, Oct 24, 2019 | 8:00p | Milwaukee Bucks | Houston Rockets | |
Thu, Oct 24, 2019 | 10:30p | Los Angeles Clippers | Golden State Warriors | |
Fri, Oct 25, 2019 | 7:00p | Toronto Raptors | Boston Celtics | |
Fri, Oct 25, 2019 | 7:00p | Minnesota Timberwolves | Charlotte Hornets | |
Fri, Oct 25, 2019 | 7:30p | New York Knicks | Brooklyn Nets | |
Fri, Oct 25, 2019 | 8:00p | Washington Wizards | Oklahoma City Thunder | |
Fri, Oct 25, 2019 | 8:00p | Dallas Mavericks | New Orleans Pelicans | |
Fri, Oct 25, 2019 | 8:00p | Chicago Bulls | Memphis Grizzlies | |
Fri, Oct 25, 2019 | 9:00p | Phoenix Suns | Denver Nuggets | |
Fri, Oct 25, 2019 | 10:00p | Portland Trail Blazers | Sacramento Kings | |
Fri, Oct 25, 2019 | 10:30p | Utah Jazz | Los Angeles Lakers | |
Sat, Oct 26, 2019 | 5:00p | Miami Heat | Milwaukee Bucks | |
Sat, Oct 26, 2019 | 7:00p | Philadelphia 76ers | Detroit Pistons | |
Sat, Oct 26, 2019 | 7:30p | Orlando Magic | Atlanta Hawks | |
Sat, Oct 26, 2019 | 7:30p | Boston Celtics | New York Knicks | |
Sat, Oct 26, 2019 | 8:00p | New Orleans Pelicans | Houston Rockets | |
Sat, Oct 26, 2019 | 8:00p | Indiana Pacers | Cleveland Cavaliers | |
Sat, Oct 26, 2019 | 8:00p | Toronto Raptors | Chicago Bulls | |
Sat, Oct 26, 2019 | 8:30p | Washington Wizards | San Antonio Spurs | |
Sat, Oct 26, 2019 | 9:00p | Sacramento Kings | Utah Jazz | |
Sat, Oct 26, 2019 | 10:00p | Los Angeles Clippers | Phoenix Suns |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>