Hi,
Can someone help me with a TRANSPOSE formula please. I ma trying to compare what each Division of a company reports they are owed or owe to another Division of a Company.
I've used Divisions A,B,C,D and E has an example. Division A has reported that they are owed 2,000 (A positive figure) by Division B. Division B reports that it owes Division A -100 (A negative number). A differnece of 1,900.
I am trying to put a table together underneath to show this 1,900. I have put in a formula per the image in Cell B14. Can someone tell me how to fix this please? I am using Excel O365.
Kind regards,
James
Can someone help me with a TRANSPOSE formula please. I ma trying to compare what each Division of a company reports they are owed or owe to another Division of a Company.
I've used Divisions A,B,C,D and E has an example. Division A has reported that they are owed 2,000 (A positive figure) by Division B. Division B reports that it owes Division A -100 (A negative number). A differnece of 1,900.
I am trying to put a table together underneath to show this 1,900. I have put in a formula per the image in Cell B14. Can someone tell me how to fix this please? I am using Excel O365.
Kind regards,
James