Hello,
I've been trying to hack together code that will let me do the following:
1) In a certain column find duplicates.
2) For those duplicates check another column for duplicates
3) If found, highlight the rows.
I have searched and found a thread which seemed an almost exact match but now I'm stuck: http://www.excelforum.com/excel-form...lete-rows.html
The attached file should be helpful
tester.xlsx
The code I have found in the thread mentioned got me far, but now I'm stuck. Also I must admit that I do not know what I am doing. That is because the code does not have enough comments too explain what it does.
The result of the above code is highlighting a couple (wrong) cells. I know I should get rid of the Union declarations, but I don't know how to make sure the correct rows are highlighted. Also I do not understand how this code exactly finds duplicates in the first column, saves the rows which are dupes, and then checks for duplicates in those rows but in another column.Please Login or Register to view this content.
As far as I understand it this will get all the entries in de B column, then put them in a dictionary array. But then it starts counting (I do not understand why) and after that I just do not have the skills to understand the code... yet .
Any help would be greatly appreciated!
Bookmarks