Deleting rows with duplicate values in two columns?

[#1]

Hello, 

I need to delete multiple rows from my data table that have duplicate values in two columns I specify while preserving the first instance of the row. In the example below, only the third row would be deleted, as both columns are duplicates of row 1. Since the C rows have different results they would not be deleted, even though the entry is duplicated within the column. 

ID	Result
A	X
B	Y
A	X
C	Z
D	Z
C	X

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, such as a JMP script, would be preferred as my data table is a couple of thousand rows tall, and I would really prefer not to do this by hand. Let me know if I need to clarify anything. Thanks!

[#2 · Accepted solution]

Select your columns, Select Duplicate Rows, Delete Rows

JMP is able to write a script for that action to enhanced log / workflow

dt << Select Duplicate Rows(Match(:ID, :Result)) << Delete Rows;

[#3]

Oh, that's super easy thanks!