comparing two columns?

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" <forum@nospam.OfficeKB.com> wrote in message
news:7fe142636f8846d9a70113c1181ff508@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?