However a special tool for duplicate records was still missing... until now!
You could already identify or remove duplicated records with a workaround by merging the cell contents into a temporary added column and then use ASAP Utilities' "Conditional row and column select, hide or delete..." tool on this new column to remove the duplicated rows. But that involved a few extra steps and it isn't as fast as this new utility.
In the new version of ASAP Utilities you will be able to quickly remove all duplicated records from your sheet:
Besides removing the duplicates from a single sheet, you can also choose the option "Remove the records from Dataset 1 that are found identical in Dataset 2". This can for example be used if you have two sheets with addresses and the persons on one of the sheets have already be contacted. You can then remove those from the first sheet to get a list of people that still need to be contacted.
You can also choose the following options:
- Case sensitive.
If you choose this option then the comparison is made case senstive. This means for example that "Bastien" does not equal "BASTIEN".
- Ignore leading, trailing and excessive spaces (example: "bastien" equals " bastien")
If you choose this option than it doesn't matter if some cells have irregular spacing. This can be useful if the data isn't always entered properly. Especially trailing spaces sometime cause problems when it comes to comparing lists.
- Hide the rows instead of removing them
Download and use
You can read more information and download the pre-release of the new version from:
You can start this new (experimental and only in English) tool via:
ASAP Utilities Options » New tools in development (experimental, English only)
and then click on the button "Manage duplicated records":