What formula do I need to type in Column B cells to identify the duplicated
entry (only the second entry)


Column A Column B

Car
Toy
Bed
Sofa
Car Duplicate
Chair
Desk
Watch
Toy Duplicate