Register
Log In
Unanswered
Home
June 25, 2016
Offline
A. B. C. D
Date Dr Cr
7/5/16 10
8/5/16 12.5
10/5/16 10
11/5/16 12.5
13/5/16 12.5
........................................
I want to match Dr amount and Cr amount if amount the same it appears in next column otherwise blank,
Regards,
See Answer
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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)?
June 25, 2016
Offline
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.
Dashboards
June 25, 2016
Offline
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
June 25, 2016
Offline
Nice,but my date is different not the same date.any solution
Thanks
SunnyKow said
Hi RathanakI 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
Dashboards
June 25, 2016
Offline
Hi rathanak
Please post sample worksheet with enough data and expected result for easy understanding
Sunny Kow
June 25, 2016
Offline
My
SunnyKow said
Hi rathanakPlease 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
June 25, 2016
Offline
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
Mydata 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 rathanakPlease 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
July 16, 2010
Offline
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
Answers Post
Dashboards
June 25, 2016
Offline
I totally agree with Mynda. Use a helper column. It will save you a lot of trouble
Sunny Kow
June 25, 2016
Offline
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 🙂
Most Users Ever Online: 57
Currently Online: clark shao
9 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
