Hi Cynthia

In B1
=IF(COUNTIF(A:A,A1)1,A1,"")
copy down column B as far as required.

--
Regards

Roger Govier


"Cynthia Amrit" <Cynthia wrote in
message ...
I need to find duplicates within a column. I want it to say what is the
duplicate and the non duplicate to blank in column B.


A B
Dog Dog
Fish
Dog
Cat Cat
Rabbit
Cat