S
sax30
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:
Table #1
LastName FirstName SSN Address
PhoneNumber
Smith John 111-11-1111 123 Usa St.
123-458-9999
Smith Tim 222-22-2222 321 Main St.
123-444-5555
Table #2
LastName FirstName SSN Address
PhoneNumber
Smith John 111-11-1111 123 Usa St.
123-458-9999
Smith Tim 222-22-2222 321 Main St.
123-444-5555
Brunell Mark 333-33-3333 444 Usa St.
123-555-9999
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!
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:
Table #1
LastName FirstName SSN Address
PhoneNumber
Smith John 111-11-1111 123 Usa St.
123-458-9999
Smith Tim 222-22-2222 321 Main St.
123-444-5555
Table #2
LastName FirstName SSN Address
PhoneNumber
Smith John 111-11-1111 123 Usa St.
123-458-9999
Smith Tim 222-22-2222 321 Main St.
123-444-5555
Brunell Mark 333-33-3333 444 Usa St.
123-555-9999
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!