see reply to your earlier posting

--
Regards

Roger Govier


"Cynthia Amrit" <Cynthia wrote in
message ...
I am looking for duplicates within column A and in column B I want it
to say
the duplicates and then the non-duplicates I want to be blank.

Column A Column B
Fish Fish
Dog
Rabbit Rabbit
Fish
Rabbit