Hi:
I'm trying to figure out a way to remove duplicate records (rows) from a large Excel spreadsheet. If there isn't an easy way to do this in Excel, maybe there is a way in Access.
Example data:
1236 - Tom Jones
1696 - Jim Smith
1788 - Aimee Hunts
1236 - Toms Jones (duplicate)
1966 - Billy Bob
2039 - Jessica Sams
1788 - Aimee Hunts (duplicate)
Thanks!
I'm trying to figure out a way to remove duplicate records (rows) from a large Excel spreadsheet. If there isn't an easy way to do this in Excel, maybe there is a way in Access.
Example data:
1236 - Tom Jones
1696 - Jim Smith
1788 - Aimee Hunts
1236 - Toms Jones (duplicate)
1966 - Billy Bob
2039 - Jessica Sams
1788 - Aimee Hunts (duplicate)
Thanks!