Previous Topic Next Topic

To compare substrings of two columns

Closed
GD - 18 Mar 2011 à 12:34
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Mar 2011 à 08:29
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.
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
18 Mar 2011 à 13:48
what is answer here

San Fransisco apartments--------------Kings of San Francisco Valley------- ????
GD
19 Mar 2011 à 06:17
for that also i was looking to get Match
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
19 Mar 2011 à 20:30
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
20 Mar 2011 à 04:32
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Mar 2011 à 08:29
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

How to Compare two workbooks and see if data has moved or not?
hoosier1851 -
TrowaD -

1 response
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
Opening a word document in multiple versions
elizas -
closeup22 -

1 response
Comparing columns and returning value
ll -
kittu -

35 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses