A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft 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.