How do I locate matches of names from two or more lists on names in Excel?

http://www.cpearson.com/excel/duplicat.htm

"LBTeacher" wrote:

How do I locate matches of names from two or more lists on names in Excel?

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 :)

"LBTeacher" wrote:

How do I locate matches of names from two or more lists on names in Excel?

Sorry, see corrections below

"pameluh" wrote:

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 :)

"LBTeacher" wrote:

How do I locate matches of names from two or more lists on names in Excel?