Typically used to remove duplications in lists, it can also summarize your data for unique values in specific columns.
Select Columns – select columns by position (column letter), or By Name, Duplicate rows are rows with the same values in all of the selected columns.
Duplicates – select to Keep or Remove all rows that have duplicates, or to Keep a single row with Aggregates for each unselected of the columns. For text columns, the ‘All (list)’ option will contain a comma-separated list of all values.
Singles – select to Keep or Remove rows that do not have duplicate rows in the table.
Ignore case – when performing the duplicate check, match rows even if they have differing upper or lower case letters.
Ignore spaces – when performing the duplicate check, match rows even if they differ because of different spacing (leading, trailing or within the text).
Add Count column – add a column to the table, named ‘Count’, with a count of the number of rows represented.
Blog article: Using the Duplicates Function