Chip has lots of great stuff on duplicates. Visit www.cpearson.com
Return here if still in need of help
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Pammy" wrote in message
...
I have a workbook with 10 sheets, on the 11th sheet I would like to create
a
formula that would look on these 10 sheets and find the duplicates and
bring
back what sheet it is duplicated on. Also, would there be a way to
include
in the formula a way to mark the text so on that worksheet I would see it.