Need help identifying version x of a code per product type.
I have 3 columns, the first column contains a code (random number), the second columns contains the version of the code, the third colum contains the product within the code.
Looks like this:
A B C
48996 1 48996-1
48996 0 48996-1
48996 2 48996-2
47543 8 47543-11
47543 7 47543-10
40004 0 40004-3
41456 0 41456-4
41762 0 41762-1
It reads, product type 48996-1 has two versions: 0 and 1
I need to identify the codes that only have had version '0'. these codes can't have version '1' or '2' or '3' per product type (Column C)
From the data above, the codes that meet my criteria are: 40004 for product type 40004-3, 41456 for product type 41456-4, and 41762 for product type 41762-1.
My total dataset contains 400K rows. Help!
Bookmarks