isabelly1122
New Member
Hello Everyone,
Attached excel sheet contains loan ledger of different project with each other. Loan received vs loan given. All i need is a formulae that can subtract the value using the same name of project in Column and row.
For example D10 and E8 shows loan given and received from Each other (Presidency vs Excellency)
Result Required in Cell E8 should be ( E8-D10 or vice versa) Similarly result required in cell D10 is ( E8-D 10 or vice versa) Any formulae should look at the same value in column and row and subtract each other). At the end of the day my goal is to match project loan with each other and all the values should be 0
Attached excel sheet contains loan ledger of different project with each other. Loan received vs loan given. All i need is a formulae that can subtract the value using the same name of project in Column and row.
For example D10 and E8 shows loan given and received from Each other (Presidency vs Excellency)
Result Required in Cell E8 should be ( E8-D10 or vice versa) Similarly result required in cell D10 is ( E8-D 10 or vice versa) Any formulae should look at the same value in column and row and subtract each other). At the end of the day my goal is to match project loan with each other and all the values should be 0