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.

Use INDEX and MATCH for simple database queries in Excel The bigger your spreadsheet, the more you need these, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

Learn how to clean and organize messy Excel data with manual techniques and Power Query automation. Save time and boost accuracy today.