Hi,

I need help with the following -

There are 2 columns in my worksheet -

ColA ColB
A 1
B 2
1 A
2 B
2 D
C 3

I need to have a formula or code which can give me the pair such as A 1 (which has a 1 A in the 3rd row). What my code should not select are pairs like B 2 , because though it has 2 B, but it also has 2 D. So, ultimately I need pairs which have one-one relationship only.

Thank you,
SB