I have been trying to get a solution - specific amount on specific date for specific person - using a formula.
I have in my sample, two persons who hold cash (positive) or owe money (negative) during the range of dates. If I select the specific date for specific person, I should get the answer.
tABLE.PNG
Test.xlsx
Can somebody help to write the correct formula or write some VBA script?
Thanks
Roshan Shakya
Bookmarks