Comparing two columns

Closed
donaustin Posts 3 Registration date Monday December 8, 2014 Status Member Last seen December 9, 2014 - Dec 8, 2014 at 12:00 PM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 - Dec 11, 2014 at 10:56 AM
I have two columns both of which contain list of names.i want to get the output as true if the names are somewhat similar eg dane john and dwayne john. thanks in advance for your help.

2 replies

xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,830
Dec 8, 2014 at 04:57 PM
The computer can't process "somewhat similar " it only can handle equal or not equal.
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Dec 9, 2014 at 11:50 AM
or partially equal, but I guess that is the same as equal from a computers point of view.

Consider the option to use text delimiter to split first from last name and then compare first to first and last to last.
0
donaustin Posts 3 Registration date Monday December 8, 2014 Status Member Last seen December 9, 2014
Dec 9, 2014 at 12:03 PM
how can i do that mr trowa d
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Dec 11, 2014 at 10:56 AM
Hi Donaustin,

That would depend on your data. If both names to compare are on the same row then use text delimiter first ( found under the data tab of the excel ribbon).

Your data will now be on columns A:D.
Then in column E you can use this formula:
=IF(OR(A2=C2,B2=D2),TRUE,FALSE)

If that doesn't work then provide some rows of sample data.

Best regards,
Trowa
0