• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fuzzy lookup issues

shili12

Member
I am performing a reconciliation of Paybill statement using the fuzzy lookup feature, from our system, there is likelihood of data entry errors (errors of transposition, omission,insertions) , however when we get the paybill statement , it is, of course, accurate.
Now whilst performing the fuzzy lookups, in some instances i got 0.000 similarity threshold, why? Despite the two codes are near match.
And what is the function of this feature, to drag to left or right ?? statistical based explanations are welcome62722
 

Attachments

Last edited:

Chihiro

Excel Ninja
No need to adjust unless you wish to limit result (drag right will only keep results above threshold). Or return results with lower score (drag left).
 
Top