This sounds like it should be simple, but I am struggling. Thank you in advance
I have 2 columns of data similar to the below (but 44,000 rows). First column is an account number, second is an identifier. I need to identify the where an account number has both a 2 and 1.
<colgroup><col><col></colgroup><tbody>
</tbody>
I have 2 columns of data similar to the below (but 44,000 rows). First column is an account number, second is an identifier. I need to identify the where an account number has both a 2 and 1.
212210 | 2 |
212210 | 2 |
212210 | 2 |
212210 | 2 |
212210 | 1 |
212210 | 1 |
212210 | 1 |
212210 | 1 |
<colgroup><col><col></colgroup><tbody>
</tbody>