Hi Alex

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

for lots of things you can do with duplications, including getting a count
of unique items

Cheers
JulieD

"Alex H" wrote in message
...
Hi I have a colum that has numeric values in, some of which are
duplicated. is it possible to do a count of the number of different values
please

Thanks
A