VBA to Delete Duplicate Info on Same Date

[BigDawg15]

Hello,

Attached is a workbook with an example for two dates showing the teams who are playing on those dates. The far right column numbers show the team matchups
that are duplicates. I am looking for a macro that would delete the second team matchup for each date.

Any help or ideas would be appreciated.

Thanks in advance,

Edit: I've done some more research and if someone has a formula to number duplicates like Ive done in column I or similar for same date, I can use the remove duplicates in Excel.

Also posted at:
https://www.mrexcel.com/board/thread...-date.1172977/

BigDawg15

Dup Teams Example.xlsx

[BigDawg15]

Solved @ other forum.