Hi J1. Try out Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm

--
Sincerely, Michael Colvin


"J1" wrote:

I would like to search for repeat data in my excel worksheet, and get rid of
some useless information in another cell relating to the repeated data. Can
anyone help me with a formula?