Hi, my data has two columns named Child and Parent. The child values are duplicated and span multiple rows. Each child has multiple parents. I'd like to use a formula to search for those child that has the same parents in column B (in this example, 1022 and 1069).
Thanks so much in advance!
Wnll
Child Parent
1012 C28102
1012 C7057
1022 C20187
1022 C20187
1022 C20187
1041 C13018
1041 C3367
1065 C83482
1065 C7057
1065 C89680
1065 C6487
1069 C13018
1069 C13018
Thanks so much in advance!
Wnll
Child Parent
1012 C28102
1012 C7057
1022 C20187
1022 C20187
1022 C20187
1041 C13018
1041 C3367
1065 C83482
1065 C7057
1065 C89680
1065 C6487
1069 C13018
1069 C13018