Write A+B=B+A with Excel Function

[Yami_Excel]

Hi all,

I'm trying to build this model A+B = B+A with Excel function (pls let me know if this can only be done with VBA, i'm not too sure)

Criteria:
* A+B = B+A at all times
* Require to check if this A+B = B+A is true
* If not true, show the difference
* A+B = some value
* B+A = some value
* It's possible that the value of A+B does not equal to the value of B+A
* Be prepared for the subset content of A and B to expand...I've thought of listing out all possibilities and checking with vlookup but it would be too much to maintain when this grows to millions of pairs.

Thanks,
Yami

[Olly]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Yami_Excel]

Hi, I've been trying to upload the worksheet but something about this website is not working. I only see a bubble as clicking on the file upload icon. Already tried in multiple different browsers including IE, Safari, Firefox, Chrome. None of them works though.

Excel link:
https gofile.io/?c=Vbi0dE

In case you cannot access the link, here it is:

Enity Intercompany E + I Difference
A001 A002 A001A002 Asset $100 $0
A002 A001 A002A001 Liability $100

A001 A003 A001A003 Asset $100 $10
A003 A001 A003A001 Liability $90

A001 A004 A001A002 Asset $100 $0
A001 A004 A001A002 Liability $0
A004 A001 A002A001 Liability $100

Logic:
Need to automate A+B = B+A so that they would cancel each other out
Asset of A+B cancels with Liability of B+A



Formula View:

Enity Intercompany E + I Difference
A001 A002 =A2&B2 Asset 100 =E2-E3
A002 A001 =A3&B3 Liability 100

A001 A003 =A5&B5 Asset 100 =E5-E6
A003 A001 =A6&B6 Liability 90

A001 A004 A001A002 Asset 100 =E8-E9-E10
A001 A004 A001A002 Liability 0
A004 A001 A002A001 Liability 100

Logic:
Need to automate A+B = B+A so that they would cancel each other out
Asset of A+B cancels with Liability of B+A

[AliGW]

Please read the instructions again and attach the workbook here. Many members cannot or will not follow external links.

[Yami_Excel]

hi, sorry, i'll contribute elsewhere before coming back to this then. thx