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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 11, 2014 at 10:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 11, 2014 at 10:56 AM
Related:
- Comparing two columns
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- How to remove columns in word - Guide
- Excel compare two sheets - Guide
- Excel compare two columns for partial matches - Guide
2 responses
xpcman
Posts
19528
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,824
Dec 8, 2014 at 04:57 PM
Dec 8, 2014 at 04:57 PM
The computer can't process "somewhat similar " it only can handle equal or not equal.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 11, 2014 at 10:56 AM
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
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
Dec 9, 2014 at 11:50 AM
Consider the option to use text delimiter to split first from last name and then compare first to first and last to last.
Dec 9, 2014 at 12:03 PM