You can try something like this. You'll have to modify it for different
tabs, and depending on your data you may have to first concatonate two
or more columns to get a unique key.

I'm going to use a simple example.


Assume you have a column of names in column A.

In cell B5 type the formula =VLOOKUP(A5,A$1:A4,1,false), and copy it up
and down column B alongside the names in column A.

The first instance of each name will have a #N/A next to it. These you
apparently want to keep, and delete the others.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=515598