Mtch formula required

[Closed]
Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,

In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum letters in each cell


1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Can you re-phrase the question as I am not sure what you mean.

Do you want to join Col. B and and Col. C together and match against Col. A?
If true and a match is found then what do you want to happen?
Where do you want the result to go?