Hi TotallyConfused,

See Chip Pearson's Duplicates page for various suggestions:

http://www.cpearson.com/excel/duplic...tingDuplicates

If you wish to compare multi-column tables, you could, perhaps, add a helper
column to each table: in the helper columns add an appropriate concatenation
formula, e.g.:

= A2 & B2 & D2

where columns A,B and C house the first name, last name and city data

Then run the comparison tests on the concatenated helper columns.

---
Regards,
Norman


"TotallyConfused" wrote in
message ...
How can you compare two tables in excel to identify matches and no matches
using formulas. For instance both tables have the same information. The
only unique information would be first name and last name but different
cities. Any help will be greatly appreciated. Thank you.