Highlighting or even deleting copy records in Excel is straightforward but listing them is not as easy. The good thing is, you can use Energy Query to effortlessly display a record of replicate values or information.
How to use Power Query to display a list of duplicate values or records in Excel