Forum Discussion
Removing duplicates
Hello, I have one column that is dates rounded to the nearest 00:00 and I want to remove any duplicates from this column whilst deleting all the data on these rows? I can only get it to remove th...
Select entire rows, then click Remove Duplicates on the Data tab of the ribbon.
Use the check boxes in the dialog to specify the column to look at for duplicates.