Comparing 2 Columns with a 3rd column (3rd column has to be unique)

[Jairacha]

Hi I am trying to compare 2 columns with a 3rd column to see if there are multiple values in the 3rd column for identical values in the first 2 columns.

For e.g.

Test1	Test2	Test3
A	1	X
B	2	Y
C	3	Z
B	3	X
A	1	Y

Here, I am trying to make sure that 

A

1

is only associated with X and not with Y as shown in 

A

1

Y

How can i filter out the above row?

[T_Willins · Accepted solution]

Hi @Jairacha,

Concatenate the first two columns and find unique values on the concatenated value.