Take a look at

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


In article ,
"Bottle" wrote:

I have a coloum of number and i want to find out if there
are any duplicated in the cells. I cannont sort them.

i.e i would like to highlight the whole coloum and have a
cell that will come up with a message to say if there is
any duplicates.

i am adding to this cell periodcally so i will be able to
identify the duplication.

Thanks