Visit Chip at www.cpearson.com . He has lots of stuff on duplicates
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"wynand" wrote in message
...
my data is on two different sheets in one workbook (sheet1-A1:A200 and
sheet2- A1:A1096) .
would like to compare the two columns for duplicates and extract to a new
sheet or higlight duplicates in order for further detailed analysis.