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.

The first is to check for duplication, then for entries where duplication is intended, but you need to know the number of occurrences. If you need to count duplicate values in a column in Excel ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Additionally, if you attempt to enter an invoice with a duplicate invoice number, most software will warn you. To create sequential invoice numbering manually, use a list of sequential numbers.