Duplicate Look up

E

Excel Crazy

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
 
M

Max

One way ..
Assuming data in A1, down
Put in B1:
=IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","")
Copy down as far as required
 
Top