"Max" wrote in message
...
"sax30" wrote in message
...

Hi,

Let's say that I have two excel tables and both have the same field
names which contains data like Name, Social Security Number,
Address....and so far. For example:
....
Noticed that table #2 has an extra person. Otherwise they are both the
same. Now, Is there a way that I can do to make excel to point out that
333-33-3333 does not match any number in the table #1? If yes, please
show me the steps to get it done. The above is just a simple example.
My tables has hundred of names and it will take forever to check off one
by one manually on both table in order to see which table has a data
that does not match. Thanks in advance!

Take a look at this product called "Excel Compare":
http://www.formulasoft.com/xlsc.html