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?
Solved! Go to Solution.