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?

Find repeat data in a worksheet
 

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?