Hi all
,
I've had a look on the forum, but cant quite find what I'm looking for. So hopefully you can help!
Here is an example:
[TABLE="width: 120"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Org1[/TD]
[TD]Org1[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD]Org2[/TD]
[TD]Org1[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD]Org3[/TD]
[TD]Org1[/TD]
[TD]Org4[/TD]
[/TR]
[TR]
[TD]Org4[/TD]
[TD]Org1[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD]Org5[/TD]
[TD]Org2[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org2[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org2[/TD]
[TD]Org4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org2[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org4[/TD]
[/TR]
</tbody>[/TABLE]
Column A will hold the data sets (will be a variable list).
Column B & C should output all 'bi-directional' pairs that could be created by column A.
Notice that they aren't paired with themselves though - thats the bit I can't find an answer to!
Can someone help me with the VBA for this please![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks in advance!
Harry
![Thumbs up :bow: :bow:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44d.png)
I've had a look on the forum, but cant quite find what I'm looking for. So hopefully you can help!
Here is an example:
[TABLE="width: 120"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Org1[/TD]
[TD]Org1[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD]Org2[/TD]
[TD]Org1[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD]Org3[/TD]
[TD]Org1[/TD]
[TD]Org4[/TD]
[/TR]
[TR]
[TD]Org4[/TD]
[TD]Org1[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD]Org5[/TD]
[TD]Org2[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org2[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org2[/TD]
[TD]Org4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org2[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org3[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org4[/TD]
[TD]Org5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Org5[/TD]
[TD]Org4[/TD]
[/TR]
</tbody>[/TABLE]
Column A will hold the data sets (will be a variable list).
Column B & C should output all 'bi-directional' pairs that could be created by column A.
Notice that they aren't paired with themselves though - thats the bit I can't find an answer to!
Can someone help me with the VBA for this please
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks in advance!
Harry