June 25, 2016
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,
VIP
April 21, 2015
Hi Rathanak,
What's different from your post https://www.myonlinetraininghu.....tiple-days and the answers given there (such as https://www.myonlinetraininghu.....on-formula)?
VIP
Trusted Members
June 25, 2016
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
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
VIP
Trusted Members
June 25, 2016
June 25, 2016
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
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.myonlinetraininghu.....on-formula
See solution attached.
Mynda
Answers Post
VIP
Trusted Members
June 25, 2016
June 25, 2016
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.myonlinetraininghu.....on-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 🙂
1 Guest(s)