The output needs to also retain those rows where no duplication occured.
EXCEL REMOVE DUPLICATE ROWS ALL COLUMNS CODE
The test result shows it managed to remove some duplicates but only dropped one duplicate eg were two the same - the purple values in the test result worksheet show still two duplicates (cells q11 and q12)- in the original sheet this value was in this column three times therefore it seems the code has only dropped one of the duplicates out - so the code needs to drop more in cases where there are more than one duplicate.Īlso the test result worksheet also shows the code does not keep rows in cases where there was only one value with no duplication in the original worksheet. I did change the start range to row 7 and it ran well with row 7 being the last row of headings. The code you suggest is almost there but doesn't quite do it - I have tried to modify but I cant get it there.
Thanks for your help ( I need it as this is beyond my level of VBA knowledge so I would be good to see how it can be done)
In the same test file - starting at row 35 is what the resulting file should look like, exactly the same -just having removed duplicated row of only columns M, O, P ,Q and R.Īnd the result also has a tally for each of these columns of how many times a value apears in each column after the duplicates have been removed see test file.Īs an after thought it would be nice if he resulting file could be output into a new worksheet - keeping the original worksheet unchanged. I have made a test /demonstation file as attached - it has the format required with some duplicate values in the columns mentioned (these are coloured in this test file only for ease of demonstration - in the real file the cells where values appear are not coloured).
Your code of course worked in a fashion, perhaps I need to be clearer - in that I would like to keep the format of the original file without the rows where there had been duplicates only in the columns mentioned being M, O, P ,Q and R. Re: Remove Duplicates Of Multiple Columns
0 kommentar(er)
