Page 1 of 1
ReconcileTxn new
Posted: Fri Oct 16, 2020 6:38 pm
by sna
Hi Dear
I come again with issue date extract and rate
So Reconcile Txn highlight all cells because date and rate no matching.
Note date in AH and rate in AJ Sheet Intranet
Best wishes
Re: ReconcileTxn new
Posted: Fri Oct 16, 2020 10:10 pm
by snasui
Where is the correct result?
Re: ReconcileTxn new
Posted: Fri Oct 16, 2020 11:28 pm
by sna
I want to compare value of items in Sheet Reconcile Txn.the result should be true in column AB otherwise false so if it is false range be highlighted.
Best wishes
Re: ReconcileTxn new
Posted: Sat Oct 17, 2020 4:48 pm
by sna
The date and rate no matching.is there any formula to handle this matter?
Re: ReconcileTxn new
Posted: Sun Oct 18, 2020 8:12 am
by snasui
Is this the same subject of
viewtopic.php?p=103986#p103986 and why you create a new one?
If the subject is the same, you can continue posting on that subject.
Please point to the row of record that show incorrect data, show me the correct value and how to calculate.
Re: ReconcileTxn new
Posted: Sun Oct 18, 2020 10:01 am
by sna
Hi Dear,
It's the same but I don't want to make it's long.so I create new because the old thread is solved.but now come up with date extract and rate extract.it got a problem because the cells highlight yellow .it means it is no matching.
Best Regards
Re: ReconcileTxn new
Posted: Sun Oct 18, 2020 10:12 am
by sna
In Sheet Intranet
IF(AG6="","",LEFT(S6,9)) this formula to get date from S6
This formula below to extract rate from M6
=IF(M6,LEFT(M6,FIND("%",M6&"%")-1)*IF(M6<0.59,12*100,IF(COUNT(SEARCH({"per year","ក្នុងមួយឆ្នាំ"," ក្នុង1ឆ្នាំ","1year"},M6)),1,12)),"")
It error those part
Re: ReconcileTxn new
Posted: Sun Oct 18, 2020 12:07 pm
by snasui
sna wrote: Sun Oct 18, 2020 10:01 amIt's the same
Sorry for inform that you must post in old subject.
sna wrote: Sun Oct 18, 2020 10:12 am
In Sheet Intranet
IF(AG6="","",LEFT(S6,9)) this formula to get date from S6
This formula below to extract rate from M6
=IF(M6,LEFT(M6,FIND("%",M6&"%")-1)*IF(M6<0.59,12*100,IF(COUNT(SEARCH({"per year","ក្នុងមួយឆ្នាំ"," ក្នុង1ឆ្នាំ","1year"},M6)),1,12)),"")
It error those part
I won't transform above formula to your condition. Please explain all condition you use instead.
Re: ReconcileTxn new
Posted: Sun Oct 18, 2020 1:29 pm
by sna
Ok I shall post in old