I have a problem that I am stumped as to how to solve.

I have multiple databases with several people who are in more than one of the databases. I have merged all the databases into one file by creating a new file and importing all the old databases as new tables. My problem is that there are no unique identifiers that identifies each individual!!! I need to get a list of everyone who is duplicated in more than one table so that I can create a "key table" where everyone can be listed and assigned a unique identifier. I have no idea how to go about this short of manually typing in each persons name in each table to see if they come up.

Any ideas?

P.S. I am very new to this so may need babied through the steps .

The easiest/fastest way I found to do this, is by exporting the table with the duplicate records into an excel worksheet, opening it into excel & using the "advanced sort" to remove duplicates.

If you need further explanation on how to accomplish this... I recommend typing "how to remove duplicate rows in excel" into google.com