Highlighting or even deleting duplicate records in Excel is simple but listing them isn’t as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records.
Whether duplicate records are good or bad depends on specific conventions that you determine, not Excel. For the most part, duplicate data is common because many records repeat the same values within the same column.
SEE: 83 Excel tips every user should master (TechRepublic)
On the other hand, a duplicate record—where all of the values are repeated—can spell trouble when reporting and analyzing the data set at large. It’s easy to find duplicates; you can filter them out of a data set or format them using a conditional format rule. What you can’t easily do in Excel is display only the duplicate…