comparing two columns?

[steve g via OfficeKB.com]

I have two columns of phone numbers, one is column C and one is column D. I
would like to take the numbers in column D and match them to the numbers in
column C, removing the numbers that dont match. Can anyone help?

 

[JulieD]

Hi Steve

Chip Pearson has a great page on working with duplicates ...
http://www.cpearson.com/excel/duplicat.htm

have a look down the bottom of the page for comparing lists