See:

http://www.cpearson.com/excel/duplicat.htm

--

Regards,

Peo Sjoblom


"maria" wrote in message
...
how can i find repeated text on a spreadsheet, for example, i have a list
of
names that and i always update it with new names. Some of the names are
repeated. how can i find the repeated names without looking in the entire
spreadsheet myself?