Hi
I have approx 500 companies which could have a balance with each other. So in total are approx 250K combinations.
I am trying to group them to see whether the balances between them are correct or not.
For example AB-CD should be grouped with CD-AB. I have tried to find MATCH and INDEX but it keeps crashing due to the large number of cells.
I have also tried to use LOOP in VBA but is looping too many times and it crashed again. Does anyone have any suggestions?
Thank you
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Rows[/TD]
[TD="align: center"]Entity 1[/TD]
[TD="align: center"]Entity 2[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]AB[/TD]
[TD="align: center"]CD[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]EF[/TD]
[TD="align: center"]GH[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]AB[/TD]
[TD="align: center"]EF[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]GH[/TD]
[TD="align: center"]EF[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]EF[/TD]
[TD="align: center"]CD[/TD]
[/TR]
</tbody>[/TABLE]
I have approx 500 companies which could have a balance with each other. So in total are approx 250K combinations.
I am trying to group them to see whether the balances between them are correct or not.
For example AB-CD should be grouped with CD-AB. I have tried to find MATCH and INDEX but it keeps crashing due to the large number of cells.
I have also tried to use LOOP in VBA but is looping too many times and it crashed again. Does anyone have any suggestions?
Thank you
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Rows[/TD]
[TD="align: center"]Entity 1[/TD]
[TD="align: center"]Entity 2[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]AB[/TD]
[TD="align: center"]CD[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]EF[/TD]
[TD="align: center"]GH[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]AB[/TD]
[TD="align: center"]EF[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]GH[/TD]
[TD="align: center"]EF[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]EF[/TD]
[TD="align: center"]CD[/TD]
[/TR]
</tbody>[/TABLE]