Assume the following - Column A is what you want to find the dups in.
In 1st sheet insert a column next to the Column A. In Column B insert
the following and copy down - Sheet 1 (or whatever you call it). Then
copy and paste Columns A and B into a blank Sheet (sheet 6)
Do the same for Sheets 2 thru 5 pasteing the information into columns A
and B of sheet 6.
Sort Column A and insert a "Blank Row" at row 1.
Then in Cell C2 enter the following formula:
=IF(A2=A1,"Duplicate","Not Duplicate") and then copy the formula down.
You will now be able to see where the dups are and what sheet they are
located on.
The cells have to be "exactly" the same or you will get a Not Dup
return (even extra spaces) will affect the dup or not dup entry.


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