1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HELP!!! Compare duplicates to another column and make sure that column has same values

Discussion in 'Ask an Excel Question' started by Tim326515465, Apr 13, 2018.

  1. Tim326515465

    Tim326515465 New Member

    Messages:
    10
    Is it possible to make sure all duplicate values in column A and the value in column B are the same and column C will be true. If column B has different values but Column A is the same display false in column C. Example below.

    A______B____C
    123456 10 TRUE
    123456 10 TRUE
    123456 10 TRUE
    123456 10 TRUE
    123456 10 TRUE
    234567 15 FALSE
    234567 15 FALSE
    234567 20 FALSE
    234567 20 FALSE
    Last edited: Apr 13, 2018
  2. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    1,946
    upload_2018-4-13_22-31-14.png

    1] Assume your data housed in A1:B9

    2] In C1, copied down :

    =SUMPRODUCT((B$1:B$9=B1)/COUNTIF(A$1:A$9,A$1:A$9))=1

    Regards
    Bosco
    Last edited: Apr 13, 2018
  3. Tim326515465

    Tim326515465 New Member

    Messages:
    10
    Thanks for the reply but it wont work if column B has the same value later.

    Attached Files:

  4. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    1,946
    Then,

    the formula revised to :

    In C1, copied down :

    =SUMPRODUCT((A$1:A$9=A1)/COUNTIFS(A$1:A$9,A$1:A$9,B$1:B$9,B$1:B$9))=1

    Regards
    Bosco
    Thomas Kuriakose likes this.
  5. Tim326515465

    Tim326515465 New Member

    Messages:
    10

Share This Page