Sorry if title is a bit misleading. I am trying to find a way to search for duplicate data in columns 1 and 2 to see if they are on the same date that is in column 3. To clarify a bit more, I am creating a sports schedule. In columns 1 and 2 are the home and away teams. In column 3 is the date of the game. I am trying to find a way to ensure that the same team isn't listed twice in either the home or away teams on any given date. In the example below Team A and team B have 2 games on the same date and would need to be identified somehow. Any help to get me started in the right direction would be appreciated.
Thanks in advance.
<tbody>
</tbody>
Thanks in advance.
Home | Visitor | Date |
Team A | Team B | 1/1/2019 |
Team C | Team D | 1/1/2019 |
Team A | Team B | 1/2/2019 |
Team C | Team A | 1/2/2019 |
Team A | Team C | 1/3/2019 |
Team B | Team D | 1/3/2019 |
Team B | Team E | 1/3/2019 |
<tbody>
</tbody>