Duplicates

Duplicates helps you identify and remove repeated values in worksheet data. It provides the tools you need to clean data more efficiently by either highlighting duplicate cells with a chosen color or deleting duplicate rows based on exact matches. With Duplicates, you can check a selected cell range for repeated values, remove duplicates from a data range that includes headers, and decide whether duplicates are judged by a single column or a combination of selected columns. When deleting duplicates, the first unique record is kept and later duplicate rows are removed, and you can review how many duplicates were deleted. Whether you're cleaning lists or deduplicating records based on key fields, Duplicates helps you complete data cleanup accurately. Choose the documentation below that best matches your needs to learn more.

1:53