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 another worksheet so you don't accidentally lose any information. Select the range of cells that has duplicate values you want to remove.

Does remove duplicates in Excel remove the first or second?

The trick is to sort your table before using Remove duplicates . Excel always keeps the first data set of a duplicated row. All consecutive rows are removed.

Does remove duplicates in Excel remove both?

If you want to remove duplicate data from a list you can use Remove Duplicates function in excel directly, then the unique data will be saved in the list, the duplicate one will be removed.