When duplicates are eliminated, the first occurrence of the value in the list is maintained, but any subsequent occurrences are erased. Because you are deleting data permanently, it is a good practice to transfer the original range of cells or tables to a different worksheet or workbook before eliminating duplicate values.