Hello. I'm trying to figure out how to write a formula or macro to identify and suppress duplicate data. I've attached a sample of the data I'm working with. It's a college football schedule that was assembled by entering the complete schedule for each team. Therefore I have duplicates where for a given date the same game is listed twice because it was on one team's schedule as the "home" game and on the other team's schedule as the "away" game. I have considered simply deleting all the "away" games, but before I do that I need to confirm that the game dates match for each "home" and "away" game duplicate in case the data entry person made an error.
Any help/advice would be much appreciated!
Bookmarks