Forum Discussion

l_Bilal_l's avatar
l_Bilal_l
Copper Contributor
Sep 16, 2022

Fields mismatch problem

Hi everyone wish you all good day

I have the following problem

 

I have Column A and Column C.
- I know that in column C there are some materials that are identical to column A, but the names of the materials are not identical between the two columns
For example, the C3 box contains an article in the name of (the fourth book part 2) and in the field A70 (the series of the fourth book part two)
- Since part of the material name in column C is identical to part of the material name in column A.
- Through the search box, I can type the part of the article I am looking for and click on “Find all” and from there I can see all matches for what I searched for on the Excel page, and from there I can delete the match or reclassify, but this takes a lot of effort and time because it is a manual process .
- I am looking for a method or function that can tell me all the implicit matches between cells in the entire Excel page, such as saying that some of the C13 field are identical to some of the A23 and A72 field, etc.

The goal is to facilitate the classification and filtering process within Excel, despite the presence of errors in the data entry system that we cannot control due to factors beyond our control.

 

- I have more than 3,500 contacts on my phone consisting of many service and commercial institutions and businessmen. I promise you, if you can solve this problem, that I will share your information with them via WhatsApp on my personal status as an advertisement in order to benefit from them in the hope that you provide your paid services to them.

  • mtarler's avatar
    mtarler
    Silver Contributor

    l_Bilal_l  In the attached I have some 'near matching' Lambda functions.  Basically I have one called:

    NearMatches2( [value], [range], [min_letters], [direction])

    so you pass it the value to search for, the range to search over, the minimum number of letters that need to match and direction can be 'Dual'/0, 'Forward'/1, or 'Backward'/-1 to search for partial matches based on the first X characters, the last X characters or check in both directions.

    Maybe it will help.

    • l_Bilal_l's avatar
      l_Bilal_l
      Copper Contributor
      thank you so much iam gonna check it out and let you know if its work

Resources