ReconcileTxn new

[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

[snasui]

Where is the correct result?

[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

[sna]

The date and rate no matching.is there any formula to handle this matter?

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

[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

[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

[snasui]

It's the same

Sorry for inform that you must post in old subject.

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.

[sna]

Ok I shall post in old