PDA

View Full Version : [SOLVED:] VBA to Delete Duplicate Info on Same Date



BigDawg15
06-05-2021, 09:38 AM
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/threads/vba-to-delete-duplicate-info-on-same-date.1172977/

BigDawg15

28572

BigDawg15
06-14-2021, 12:35 PM
Solved @ other forum.