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.

To compare substrings of two columns
Beyond compare - Download - File management
Display two columns in data validation list but return only one - Guide
Tweetdeck larger columns - Guide
Excel compare two sheets - Guide
How to delete rows and columns in word - Guide

1 response

Answer 1 / 1

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------- ????

GD
Mar 19, 2011 at 06:17 AM

for that also i was looking to get Match

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.

GD
Mar 20, 2011 at 04:32 AM

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.

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

Similar discussions

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

Excel Macro/Code help: Creating sheet for each name in column of another sheet

formula if you have credit in one column, debit in next column

Similar discussions

Subscribe To Our Newsletter!