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?

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"steve g via OfficeKB.com" wrote in message
...
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?