I would OPEN a New Worksheet and Copy and past ALL of column A Only -
then In column B - I would use some type of identifier and (i.e Column
A, or Sheet 1, etc.). Then Copy Column G or your second column and
paste it below your new column A and then in Column B - use some type
of identifier, to identify where the column came from.
Now sort Column A. Then add sometype of "Heading" into Cell A1.
Now enter the following formula into Cell C2:
=IF(A2=A1,"Duplicate","Not Duplicate"), This will give you a listing of
which cells are duplicate and not duplicate.
Column B - will tell you were the duplicates are. Then you can filter
for Duplicate or Not Duplicate - and create a new sheet.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=502990