How to use Power Query to display a list of duplicate values or records in Excel

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.

Image: PixieMe/Shutterstock

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…

Keep reading the full content on the TechRepublic site.

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Comment