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.

Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.

1. Click anywhere inside the Excel Table that you want to load into Power Query. 2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range.

4. Load the transformed data into Excel or the Data Model. Pro tip: Create named ranges for your structured data to make it easier to reference in formulas and pivot tables.

How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.