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