• Yes this is also ok, as long as the sibling 6179298 is found and that they both have the same parent.
  • Parent 6083966 has a pair of kids 6023864 (Only Supp) & 6179298 (Only Eng). So this is a good relationship (marked in green)
  • The second time 6023864 appears it is with parent 6083977. As this parent is only present once in column A in sheet 1, the relationship is incomplete (marked in blue)
  • Third time 6023864 appears it has parent 6083968. Siblings of 6023864 can be found, but not with the same parent.
  • Another good relationship would be parent 6083967 with siblings 6023864 & 6179298.
  • The last relationship with parent 6083888 is not ok, as the text belonging to each sibling is the same. In this case "Only Supp"

I was thinking if it might be an idea to sort the data according to the Top Item ID and then for each parent check if good relationships exist? Once the search within one parent is done, repeat the loop with the second parent.