Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or Filter to discard unnecessary data | Excel Programming | |||
Removing unnecessary rows through macro | Excel Programming | |||
Removing rows when duplicated in 2 worksheets | Excel Discussion (Misc queries) | |||
removing unnecessary spaces from multiple cells | Excel Worksheet Functions | |||
Removing Unnecessary Macro Security Warnings | Excel Discussion (Misc queries) |