Hi Rathanak,

What's different from your post https://www.myonlinetraininghub.com/excel-forum/excel/bank-reconciliation-over-multiple-days and the answers given there (such as https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula )?

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.

Hi Rathanak

I have modified the formula given by Mynda to DBuck earlier.

1) The date had been modified to show dd/mm/yyyy

2) Instead of "x" in the matched column, it is showing the amount (as you requested).

I have tested it using Mynda's data and it looks alright.

Not too sure if this is what you wanted but you can give it a try.

Sunny Kow

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 DBuck earlier.

1) The date had been modified to show dd/mm/yyyy

2) Instead of "x" in the matched column, it is showing the amount (as you requested).

I have tested it using Mynda's data and it looks alright.

Not too sure if this is what you wanted but you can give it a try.

Sunny Kow  

Hi rathanak

Please post sample worksheet with enough data and expected result for easy understanding

Sunny Kow

My 

SunnyKow said
Hi rathanak

Please post sample worksheet with enough data and expected result for easy understanding

Sunny Kow  

data like you post but different from you in date I.e 13/06/16  change to 13/07/16 nd same amount both in Dr nd Cr column

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 understanding.

rathanak said
My 

data like you post but different from you in date I.e 13/06/16  change to 13/07/16 nd same amount both in Dr nd Cr coluSunnyKow said
Hi rathanak

Please post sample worksheet with enough data and expected result for easy understanding

Sunny Kow  

data like you post but different from you in date I.e 13/06/16  change to 13/07/16 nd same amount both in Dr nd Cr column

Like I told you originally, Rath. With a helper column to consolidate the Dr & Cr into one column then you can use this technique:

https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula

See solution attached.

Mynda

I totally agree with Mynda. Use a helper column. It will save you a lot of trouble 

Sunny Kow

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 technique:

https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula

See solution attached.

Mynda  

I, myself,use conditional formatting with formula =and(countif($a$2:$a$6,a1),countif($b$2:$b$6,a1))

format red color to highlight.

Thanks Mynda nd Sunny for you always help nd give some new ideas,wish u both a happy time 🙂

Hi Rath,

That formula doesn't work on your example data. What did you mean to write?

Mynda

Your formula works,my formula not works fine