Hi there
I'm trying to come up with a formula that looks for duplicates in Column B and return a value of 1 (or True) if their corresponding values in Column A does not match (as per example below, data is not be sorted in any particular order). I can find the duplicates, but struggling with the second part, so hoping someone can help......
<tbody>
</tbody>
Thanks in advance
Jay
I'm trying to come up with a formula that looks for duplicates in Column B and return a value of 1 (or True) if their corresponding values in Column A does not match (as per example below, data is not be sorted in any particular order). I can find the duplicates, but struggling with the second part, so hoping someone can help......
A | B | C |
931799 | 2344 | 0 |
931799 | 2344 | 0 |
901751 | 10101 | 1 |
931799 | 10101 | 1 |
931799 | 10102 | 0 |
901751 | 10234 | 0 |
<tbody>
</tbody>
Thanks in advance
Jay