hi,
In Ms Excel Work book, I need to match an amount of more than one presented cheqs , which are cleared today, I want to lookup the exact total of these presented cheqs which is difference from my last day closing bank account balance and current bank balance.
i ,e,
Last day bank balance was Rs.50,000
last day not presented cheqs
1. chq#123456 dated:20-08-16........... Rs.4,001
2. chq#123457 dated:21-08-16........... Rs.5,385
3. chq#123458 dated:25-08-16........... Rs.4,350
Today's bank balance was Rs.59,386.
Difference.....Rs. 9,386. (i need this diff amount automatically mentioned the two cheqs (Sr#.1&2)
Hop you understand my low English :) and solve my problem.