Deleting Rows with duplicate values in two columns

Copper Contributor

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. 

IDResult
AX
BY
AX
CZ
DZ
CX

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!

1 Reply

@Four_Rivers_KennelH 

If you are on Excel 365 you may use

=UNIQUE(range)