TexasTony
New Member
- Joined
- Jan 22, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
I have a listing of football score about 1500 row long. Some games are listed twice (from each teams perspective). I need to limit the list such that each game is listed only once.
In the attached I would want to keep one of rows 5 or 32 and delete the other. I would want to keep one of rows 31 and 34 and delete the other.
I added the highlighting manually just to illustrate.
If it matters, the maximum duplication will be once and not all games will be duplicated.
Again the data is about 1500 rows long and I'll be doing on at least 11 sets of data so finding and removing manually is difficult to impossible.
Any help is appreciated.
In the attached I would want to keep one of rows 5 or 32 and delete the other. I would want to keep one of rows 31 and 34 and delete the other.
I added the highlighting manually just to illustrate.
If it matters, the maximum duplication will be once and not all games will be duplicated.
Again the data is about 1500 rows long and I'll be doing on at least 11 sets of data so finding and removing manually is difficult to impossible.
Any help is appreciated.