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
Bookmarks