Hi Leo

Supposing your column where the duplicates are is in column E, in
another column, say F1, enter
=IF(COUNTIF($E$1:E1,E1)1,"Duplicate","")
and copy down as far as required.
This will put the Duplicate against any row where the data occurs more
than once.

--
Regards

Roger Govier


"leo" wrote in message
...
guys pls help

i wonder if there's a function that can detect duplicate input in a
cells
that can give me a message and its value?

im using ms excel 2003

thanks