L
LBTeacher
How do I locate matches of names from two or more lists on names in Excel?
P
pameluh
P
pameluh
Also, you can try copying both lists to one spreadsheet so you don't damage
your original lists. This will produce a list of entries that exist in both
lists.
For this example to work, you need to get all the data in the same column.
So, for example, list a is rows 1-15, and list b is rows 16-30 in this new
spreadsheet.
Select column A | Data | Sort | OK
This will sort your list by column A.
In the cell A2, type this formula: =if(a1=a2,a1,"")
What this formula does, is check the name in the cell below to see if it's
the same, if it does, it will spit out the name into column B.
Copy this formula down the length of your list. To do this, hover your
mouse over the bottom right corner of A2 until it turns into a black cross,
then drag down the length of your list.
Select Column B | Ctrl+C | Select Column C | Edit | Paste Special | Values |
OK
Select Columns A and B | Right click | Delete
Data | Sort | OK
Print | Give to boss | Get a raise
Hope this is helpful!
Pamela
your original lists. This will produce a list of entries that exist in both
lists.
For this example to work, you need to get all the data in the same column.
So, for example, list a is rows 1-15, and list b is rows 16-30 in this new
spreadsheet.
Select column A | Data | Sort | OK
This will sort your list by column A.
In the cell A2, type this formula: =if(a1=a2,a1,"")
What this formula does, is check the name in the cell below to see if it's
the same, if it does, it will spit out the name into column B.
Copy this formula down the length of your list. To do this, hover your
mouse over the bottom right corner of A2 until it turns into a black cross,
then drag down the length of your list.
Select Column B | Ctrl+C | Select Column C | Edit | Paste Special | Values |
OK
Select Columns A and B | Right click | Delete
Data | Sort | OK
Print | Give to boss | Get a raise
Hope this is helpful!
Pamela
P
pameluh
Sorry, see corrections below
pameluh said:Also, you can try copying both lists to one spreadsheet so you don't damage
your original lists. This will produce a list of entries that exist in both
lists.
For this example to work, you need to get all the data in the same column.
So, for example, list a is rows 1-15, and list b is rows 16-30 in this new
spreadsheet.
Select column A | Data | Sort | OK
This will sort your list by column A.
In the cell ***B2***, type this formula: =if(a1=a2,a1,"")
What this formula does, is check the name in the cell below to see if it's
the same, if it does, it will spit out the name into column B.
Copy this formula down the length of your list. To do this, hover your
mouse over the bottom right corner of A2 until it turns into a black cross,
then drag down the length of your list.
Select Column B | Ctrl+C | Select Column C | Edit | Paste Special | Values |
OK
Select Columns A and B | Right click | Delete
Data | Sort | OK
Print | Give to boss | Get a raise
Hope this is helpful!
Pamela