Find and remove duplicates - support.microsoft.com
https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d
Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.. In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK.. Remove duplicate values. When you use the Remove Duplicates feature, the duplicate data will be permanently deleted. Before you delete the duplicates, it’s a good idea to copy the original data to ...
DA: 15 PA: 44 MOZ Rank: 11