Forum Discussion
samrobinson_sr
Apr 03, 2022Copper Contributor
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...
Riny_van_Eekelen
Apr 03, 2022Platinum Contributor
samrobinson_sr On a Mac, the "Remove Duplicates" is located on the Data "top menu". Not the Data ribbon.
Alternatively, if you work in a structured table, you'll also find a similar option in the Table ribbon.
Otherwise, it works similar to what HansVogelaar described.