Comparing two lists of names in Excel and then sorting them
Closed
atjays
Posts
1
Registration date
Tuesday January 27, 2015
Status
Member
Last seen
January 27, 2015
-
Jan 27, 2015 at 05:43 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 2, 2015 at 11:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 2, 2015 at 11:27 AM
Related:
- Comparing two lists of names in Excel and then sorting them
- My contacts list names - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to find a list of names in excel ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- How to count names in excel - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Feb 2, 2015 at 11:27 AM
Feb 2, 2015 at 11:27 AM
Hi Atjays,
Take a look at the following example:
List 1 - List 2 - List 3
A2:A4 - B2:B4 - C2:C4
abc - def - ghi
ghi - jkl - mno
stu - vwx - yza
The name you want to cross check is in D2:
=SUM(($A$2:$A$4=D2)+($B$2:$B$4=D2)+($C$2:$C$4=D2))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
Putting abc in D2 will yield 1; 1 occurrence in the 3 lists.
Putting ghi in D2 will yield 2; 2 occurrences in the 3 lists.
Putting pqr in D2 will yield 0; this value is not present in the 3 lists.
The formula is ready to be dragged down for you to enter all the names you want to check in a column.
Best regards,
Trowa
Take a look at the following example:
List 1 - List 2 - List 3
A2:A4 - B2:B4 - C2:C4
abc - def - ghi
ghi - jkl - mno
stu - vwx - yza
The name you want to cross check is in D2:
=SUM(($A$2:$A$4=D2)+($B$2:$B$4=D2)+($C$2:$C$4=D2))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
Putting abc in D2 will yield 1; 1 occurrence in the 3 lists.
Putting ghi in D2 will yield 2; 2 occurrences in the 3 lists.
Putting pqr in D2 will yield 0; this value is not present in the 3 lists.
The formula is ready to be dragged down for you to enter all the names you want to check in a column.
Best regards,
Trowa