Excel users frequently want to show rows that have duplicate values in one or more columns.
This is easy to do in Easy Data Transform:
Ensuring the pink input item is selected, click the Count button in the left pane. A blue transform item is added and selected.
In the right pane select the column you want to show duplicates for.
Ensuring the blue Count transform item is selected, click the Filter button in the left pane. Another blue transform item is added and selected.
Set the filter to show only rows where Count is greater than 1.
All the duplicates are now listed, along with the count of how many times they appear. If you want to look for duplicates across multiple columns (e.g. same first name And Last name) you can use the Concat Cols transform to combine these columns before the Count.
Note that duplicate checking is sensitive to case and white space. You can use Case and Trim transforms before the Count to modify case and whitespace.
When you are happy with the results output the result into a new Excel spreadsheet or CSV file.
Easy Data Transform allows you to combine 42 different transforms to quickly and easily manipulate your data. You can also use it to remove duplicate rows in Excel.
v1.6.5 for Windows 10 / 8 / 7 (48 MB)
v1.6.5 for Mac 10.15 to 10.12 (23 MB)
Questions or problems?