Hi sunny, Thank you dear,it is awesome 🙂
Yes,thanks
Your formula works,my formula not works fine
MyndaIMynda Treacy said Like I told you originally, Rath. With a helper column to consolidate the Dr & Cr into one column then you can use this ...
I.e 13/6/16 Dr 192.50 on 13/7/16 Cr 192.50 I want this show because it is matched.I mean I want different date but same amount both Dr nd Cr hope u un...
My SunnyKow said Hi rathanak Please post sample worksheet with enough data and expected result for easy understanding Sunny Kow data lik...
Nice,but my date is different not the same date.any solution Thanks SunnyKow said Hi Rathanak I have modified the formula given by Mynda to ...
It is different from yours the Debit nd Credit in different column nd the same sign not like yours in the Same column nd different sign.
Rea SunnyKow said Hi Rathanak Glad to know it helps. There are always more than one way to solve a problem. It doesn't matter if it is a lon...
SunnyKow said Hi Frans It is not easy to explain the workings but I will try my best. I have broken down the formula for easy reference. Note :...