Thread: Find repeat data in a worksheet

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?

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?