Removing Unnecessary duplicated data
Hey Guys and Girls,
I have a data set in which one column has certain duplicated values (which are not present in the other columns, just duplicated in its own column)
I am looking for a way to remove these duplicated values in the column and then removing the associated rows with these removed duplicates.
Using De-dupe at the moment I can remove the duplicates but the rows next to the data remain. The column which has been de-duped shifts up and then scrambles the data as the associated rows have not been deleted alongside the duplicates in the column.
I fear that I have spend too much time doling out savage banter then working on my excel skills :/
Any help would be greatly appreciated! :)
|