I know this topic has been discussed alot, but I can't find the solution I need through searching.
I have a roughly 10,000 rows of data that may contain duplicate entries. There are only 4 columns (A:D). I need to delete the row only if all 4 columns are duplicates. Here's an example:
07 Blue Car 1000
07 Blue Car 3000
07 Red Truck 10000
07 Red Truck 10000
07 White Van 40000
07 White Van 40000
07 White Van 42000
It should look like this after deleting duplicates:
07 Blue Car 1000
07 Blue Car 3000
07 Red Truck 10000
07 White Van 40000
07 White Van 42000
Another problem is that I want one duplicate entry to remain as in the example above. The rows containing "white" and "van" both have 40000 listed in them. I need one of those rows to remain.
Can anyone help out? I'd greatly appreciate it. Please let me know if I need to clarify.
Thanks,
Dan
I have a roughly 10,000 rows of data that may contain duplicate entries. There are only 4 columns (A:D). I need to delete the row only if all 4 columns are duplicates. Here's an example:
07 Blue Car 1000
07 Blue Car 3000
07 Red Truck 10000
07 Red Truck 10000
07 White Van 40000
07 White Van 40000
07 White Van 42000
It should look like this after deleting duplicates:
07 Blue Car 1000
07 Blue Car 3000
07 Red Truck 10000
07 White Van 40000
07 White Van 42000
Another problem is that I want one duplicate entry to remain as in the example above. The rows containing "white" and "van" both have 40000 listed in them. I need one of those rows to remain.
Can anyone help out? I'd greatly appreciate it. Please let me know if I need to clarify.
Thanks,
Dan