Matching any 2 cells in different columns

[Tom]

I have 2 columns of phone numbers and I need to find a way
to automatically scan both columns and somehow indicate
which numbers appear in both columns. Is there a way to
do this? I tried using the MATCH function, but I couldn't
quite figure that out. If anybody can help me, that would
be great.

Also, each column of phone numbers is formatted
differently. For example, one reads (123) 456-7890 while
the other reads 123-456-7890. Is there a way to format
these so they will appear the same way?

Thank you very much.

 

[Dave Peterson]

First thing I'd do is get rid of all those extra characters from both lists.

Select the ranges and change
- to nothing (leave blank)
( to nothing
) to nothing

If you have more stuff in there, get rid of that, too.

Then try your match functions to see if they work.

You may want to look at Chip Pearson's page for duplicates:
http://www.cpearson.com/excel/Duplicat.htm
(if you get stuck)