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

Partial cell(or string) match in excel macro

AV114

Member
I am new to VBA and I would like to do a partial string (or cell) match between two sheets.

An example of
ABResult
'200001840036,'20812646883,'86414226'20000812646883,'Partially Matched with B
,'06500500108880650050010888Partially Matched
'50200009667407'50200009667407Matched
20000812646883,''200001840036,'20812646883,'86414226Partially Matched with A
Please help
 

Marc L

Excel Ninja
Start here (see in particular How to get the Best Results) :​
See also the VBA help of Range.Find method …​
 

p45cal

Well-Known Member
I am new to VBA and I would like to do a partial string (or cell) match between two sheets.

An example of
ABResult
'200001840036,'20812646883,'86414226'20000812646883,'Partially Matched with B
Some partial matching is coloured red above; how long is the smallest number of contiguous characters needed that will count as a partial match? (Clearly, if it was only 1 then nearly everything woud be a partial match.)
 

Marc L

Excel Ninja
Last 9, maybe 10 in case of comparing the same row but not necessary if comparing from all worksheet …​
The reason why initial post must crystal clear explain the need ‼​
 
Top