Forum Discussion
ow find duplicate rows In Excel and Export Rows to another sheet using vba
How find duplicate Values In Excel and Export Rows to another sheet using vba. I had an excel sheet with multiple rows and column lets say from A to K. I need to find duplicate rows only if values in...
You can use a scripting dictionary. use the values and row or col id in your entry with pipe, split the pipes and populate the other table. The find dups in excel should be faster. However if you want to ensure unique values dictionary is the easy way to go. Fill as you read the table populate as you go through. Just worrying about the col/row thing could get pretty messy pretty quick. The last few rows and cols will contain very little.