To compare substrings of two columns

Closed
GD - Mar 18, 2011 at 12:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 20, 2011 at 08:29 AM
Hello,

I was looking to compare corresponding cells of two columns for match in substrings of both the columns in Excel 2010.My data looks as
ColA-------------------------------------------------ColB-----------------------------------ColC
San Fransisco apartments-------------------San Francisco housing authorities-------Match
van neese autobody-------------------------van neese autoworks----------------------Match

I was looking to get ColC values.Can anyone suggest me to achieve this.
Thanks in advance for your valuable suggestions and time.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 18, 2011 at 01:48 PM
what is answer here

San Fransisco apartments--------------Kings of San Francisco Valley------- ????
0
for that also i was looking to get Match
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 19, 2011 at 08:30 PM
if
San Fransisco apartments--------------Kings of San Jose Valley------- is a match too, then it is very problematic. What constitute a match and what does not, needs to be very clearly defined.
0
I was looking to get match if at least one sub string is common in both of them.For
San Francisco apartments--------Kings of San Jose valley----Match
Thank you for your involvement.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 20, 2011 at 08:29 AM
There might be more efficient ways then what I am envisioning. I am thinking you would need a custom formula that will parse the search word into sub-strings and then see if based on parsed sub strings there is a match or not. Now this approach will surely suffer from performance issue, so if is even an approach that one consider will depends on number of rows to be searched and number of sub strings one has to look thru on each row
0