Combining lists

[Guest]

I have two long lists of people with the last name in column A and the first name in column B. I'm trying to find out how I can isolate the people who appear on both lists.

I was wondering if their is a formula that I could plug in between the two columns of each list, or if I could combine the information in column A and B to use the formula that you provided for my other lists

List 1 in Col A, list 2 in Col D

In B1 put =IF(COUNTIF(D,A1)>0,"MATCH","") and copy down as far as needed

In E1 put =IF(COUNTIF(A:A,D1)>0,"MATCH","") and copy down as far as needed

Again, thanks for all of your help!

Austin

 

[Ron de Bruin]

Check out this site Austin
http://www.cpearson.com/excel/duplicat.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl

I have two long lists of people with the last name in column A and the first name in column B. I'm trying to find out how I can

isolate the people who appear on both lists.

I was wondering if their is a formula that I could plug in between the two columns of each list, or if I could combine the

information in column A and B to use the formula that you provided for my other lists: