Hello, 

I need to delete mutliple rows from my workbook that have duplicate values in two columns I specify. In the example below, only the fourth row would be deleted, as both columns are duplicates of row 2. Since the C rows have different results they would not be deleted. 

IDResultAXBYAXCZDZCX

Conversely, it would work to copy all rows that have a unique combination in those two rows into a different location. 

The most efficient solution would be preferred as my workbook is a couple thousand rows tall, and I would really prefer not to do this by hand. Let me know if I need to clarify anything. Thanks!

​Hello, I need to delete mutliple rows from my workbook that have duplicate values in two columns I specify. In the example below, only the fourth row would be deleted, as both columns are duplicates of row 2. Since the C rows have different results they would not be deleted. IDResultAXBYAXCZDZCXConversely, it would work to copy all rows that have a unique combination in those two rows into a different location. The most efficient solution would be preferred as my workbook is a couple thousand rows tall, and I would really prefer not to do this by hand. Let me know if I need to clarify anything. Thanks!  Read More

​