Removing Duplicates
Remove Duplicates When you use the Remove Duplicates feature, the duplicate data is permanently deleted. Before you delete the duplicates, it’s a good idea to copy the original data to another worksheet so you don’t accidentally lose any information. 1) Select a cell in your range 2) Data > Remove Duplicates 3) Check off the criteria for removing the duplicate rows 4) Click OK See below as an example: