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
<tbody>
</tbody>
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
Rows | Entity 1 | Entity 2 |
1 | AB | CD |
2 | EF | GH |
3 | AB | EF |
4 | GH | EF |
5 | EF | CD |
<tbody>
</tbody>