comparing two columns with several text in each column

Status
Not open for further replies.

dmasvar

New Member
Joined
Nov 17, 2004
Messages
33
is there a way of comparing two colunms of text say and drawing out the similiarities, wehther exact match or partial match...

would appreciate any assistance..
eg

one column may have

cat, camp

and 2nd column could have

cake, cow

the output column 3rd column

if i ask to match "ca" it should say there is a match and bring out cat, cake camp


is this possible how do i do it.. sql?expresison builder?
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Hi

I notice that you've asked this question a number of times now, all in different threads and people (including me) have tried to help but you really need to give more information and to be honest, if people have taken the time to reply but they're asking for more info so they can try and help it's probably an idea to reply to them for courtesy sake if nothing else.

As for this version of your question - take a look at the "LIKE" expression as it may get you towards where you need to be.

Martin
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,808
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top