When using the "Delete Duplicates" function in Excel, the duplicate values in the selected range are deleted from the worksheet. Only the first occurrence of each unique value is retained.
When using the "Delete Duplicates" function in Excel, what happens to the duplicate values in the selected range?
They are replaced with blank cells.
They are highlighted with a different colour.
They are deleted from the worksheet.
They are merged into a single cell.
1 answer
1 answer