Hi Jag, Thank you for replying so quickly... When I run this code, I get a unique identifier for one of the pairs in each group, but the others are all assigned a value of 1. Any idea what I could be doing wrong? In bold below, I have highlighted the issue. The B grouping should all have a Group value of 2 and the D grouping a value of 3. Essentially I'm creating an industry identifier for each company based on its pairs. All companies in a particular industry should have the same Group value. Company Paired_Company Group Expected Value A C 1 A G 1 A F 1 A E 1 B J 2 B I 1 2 B H 1 2 C G 1 C F 1 C E 1 C A 1 D L 3 D K 1 3 E C 1 E A 1 E G 1 E F 1
... View more