Hi
Anyone here know what is the formula to find duplicate records and tag it as duplicate in col C.
I have attached a dummy file. i just wanted to tag "DUPLICATE" if the value on col B is duplicate by Col A.
Brand Unit Brand
APPLE IPHONE 5 Duplicate
APPLE IPHONE 5 Duplicate
APPLE IPHONE 5 S
APPLE IPHONE 6
APPLE IPAD MINI Duplicate
APPLE IPAD MINI Duplicate
APPLE IPAD MINI Duplicate
APPLE Iphone4 Duplicate
APPLE Iphone4 Duplicate
Samsung galaxy young
Samsung galaxy note 1
Samsung galaxy note 1
Samsung galaxy note 1
Samsung galaxy note 1
Samsung galaxy note 1
Bookmarks