Macro needed - echo merge, delete, or OK

[Armitage2k]

Hey there!

I would need help with a little problem please.

I have a file with 30.000 fows full of names, which happens to be profiles of my companys guests, but of course this database is full of duplicates.
Now I have the great honor to find the duplicates within this file and then start to merge or delete them.

Well, since I believe that this should be possible with excel, I would need some help from the local excel gods please:

The attached sample shows a few dummy entries which I would need to work on. I need the macro to:
* Evaluate the last name in column B (full name is given, but basis is the last name only)
* then check if there are any other entries with the same last name
* if yes, check if the details (address, zip, passport, nationality, etc.) from column C to M match (1 match is enough)
* if a match is given, echo in that entries column A "MERGE"

EXCEPTIONS:
* if columns, C,D,E,F,J,K,L,M are empty, echo in column A "DELETE"
* if the entry is unique (or if any other matches entries cannot be found), then echo in column A "OK"

Since I do not know if this is possible in the first place, I was wondering to maybe breakup the macro into 3 parts. One step to look for empty entries, another to look for uniques, another to look for mergeable entries. However, just an idea.

Your help is really appreciated!!!
Thanks,
A2k

[Armitage2k]

Really no ideas anyone?