Take a look at

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


In article ,
"Peter" wrote:

What is the quickest way to highlight duplications in a long column of
numbers or text? Thanks.