I need to implement the following logic in excel vba. I will appreciate any
ideas.

Thanks

Problem description -

There are 5 dimensions along which a transfer of goods happens.

Giver (G), giver channel (CH), account number (AC), taker (T), taker channel
(CH)

All of these can and do assume unique values.
Examples €“ G1, G2, G3 etc, CH1, CH2, CH3 etc and so forth

There can be any combination of these along which a transfer might take place.
Example €“ A transfer might look like

From G1, through CH3, to T4, through CH2, in account number AC5
So it looks like
G1 €“ CH3 €“ AC5 €“ CH2 €“ T4 = 100 where 100 is the amount that was transferred
in this transaction

I need to determine what total amount was transferred for each such
combination above. The problem is simple enough if the combinations are all
unique. But when the giver becomes the taker and taker becomes the giver, BUT
the channels and account number remain the same, then the transfer amount
needs to be netted.

Example:
G1 €“ CH3 €“ AC5 €“ CH2 €“ T4 = 100
T4 €“ CH3 €“ AC5 €“ CH2 €“ G1 = 10
Then this should be netted as
G1 €“ CH3 €“ AC5 €“ CH2 €“ T4 = 90


So, I need to identify such unique combinations as
G - CH €“ AC €“ CH - T
And sum (net) them.

If there were 5 G, CH, AC and T each, there would be 5x5x5x5x5 = 3125
possible combinations along which a transaction could take place. I need to
identify all those that are the same, AND ALSO, all those where everything
else if the same except the giver and taker have switched places.