De-duplicating

[Peter]

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

 

[JE McGimpsey]

Take a look at

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