How to identify duplicates using two criteria
Results 1 to 4 of 4

Thread: How to identify duplicates using two criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular Sean15's Avatar
    Join Date
    Jun 2005
    Posts
    563
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to identify duplicates using two criteria

    Hello:


    Excel 2010
    CDEFG
    1NameInvoice NoDuplicate invoice
    2Peter Paul121245no
    3PeterPaul121245yes
    4Tiffany5675225yes
    5Macy5675225no
    6Tiffany5675225yes
    7PeterPaul121245yes
    8PeterPaul1524456No

    Sheet1






    If name in column C and Invoice No in column E appears more than once, required result in column G should be "duplicate", if not "no"
    so in example above, Tiffany invoice No 5675225 appears more than once, so required value in column G should be "duplicate"
    Macy invoice No 5675225 should be tagged "No" (even though it has same invoice no as Tiffany)

    Could you help please?

    Sean

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,058
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: How to identify duplicates using two criteria

    How about
    =IF(COUNTIFS($A$2:$A$8,A2,$C$2:$C$8,C2)>1,"duplicate","no")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular Sean15's Avatar
    Join Date
    Jun 2005
    Posts
    563
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to identify duplicates using two criteria

    Thank you very much.

    Sean.

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,058
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: How to identify duplicates using two criteria

    You're welcome
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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