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
- Excel partial text match between two columns - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Excel change columns to numbers - Guide
- Macro to compare two excel sheets ✓ - Excel Forum
2 responses
xpcman
Posts
19530
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,826
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
552
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