+ Reply to Thread
Results 1 to 4 of 4

Find and Tag duplicate formula

  1. #1
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    235

    Find and Tag duplicate formula

    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
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Find and Tag duplicate formula

    hi albert. isn't Samsung Galaxy Note 1 a duplicate too? if so, try this in C2
    =IF(COUNTIFS(A:A,A2,B:B,B2)>1,"Duplicate","")

  3. #3
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    235

    Re: Find and Tag duplicate formula

    it works perfectly, thanks benishiryo.

    how about i need to tag "1" in column D if the tag from column C is duplicate per column A. For example in Apple we found duplicate Iphone 5 and i just wanted to have a tag as 1 only in the first 1 found duplicate.

    thanks.
    Col A Col B Col C Col D
    Apple Iphone 5 duplicate 1
    Apple Iphone 5 duplicate
    Apple Iphone 5s duplicate 1
    Apple Iphone 5s duplicate
    Apple Iphone 4s duplicate 1
    Apple Iphone 4s duplicate

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Find and Tag duplicate formula

    you're very welcome. try:
    =IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,1,"")

    do mark the thread as "Solved" & start a new thread for other questions

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to find duplicate entries based on certain specific conditions
    By zicitron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2013, 08:22 AM
  2. [SOLVED] Formula to Find, Match & Highlight a duplicate cell in C.F.
    By alan_stephen75@ in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-11-2013, 07:09 AM
  3. Replies: 1
    Last Post: 01-26-2012, 10:06 AM
  4. Formula assistance - find duplicate and present results
    By craighaylett in forum Excel General
    Replies: 3
    Last Post: 10-01-2010, 06:34 AM
  5. Replies: 1
    Last Post: 12-02-2005, 05:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1