Handle Duplicate Records /text/scalc/01/HandleDuplicateRecords.xhp duplicate;remove duplicate;select

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.