• 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...

  • 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

Tim326515465

New Member
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:
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:
Back
Top