View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cynthia Amrit Cynthia Amrit is offline
external usenet poster
 
Posts: 3
Default Finding duplicates within a column

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