Handle Duplicate Records

Selects or removes the duplicate rows or columns from the selection. The duplicate records dialog has various options.

Compare: specifies whether to compare rows or columns.

Header: specifies if the selected data includes table headers. If checked, the table headers (the first row or column) are ignored.

Compare by: specifies which fields to compare (and which to ignore) when determining whether two rows or columns are duplicates or not.

Action: specifies whether to select or remove the duplicate rows or columns.