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.
When duplicate records are removed, the entire rows or columns in the range containing those duplicates are deleted. This action causes the surrounding cells to shift and fill the empty spaces left behind. If the comparison is conducted along the rows, the cells below the removed duplicates will shift upward. Conversely, if the comparison is done along the columns, the cells to the right of the deleted duplicates will move leftward.