I have a helper column where I have formulas that returns "DUP-####-XXXXX".
DUP represents duplicate
#### represent a part number
xxxxx represents the package name that the part is in.
My dilemma is lots of time the part number might be used twice in one package and only once in another package...i.e.:
But I want a column that I can filter and see all three...
DUP-1234-Test1
DUP-1234-Test2
DUP-1234-Test2
I had another column where I used COUNTIF to identify the duplicates, but I have lots of part numbers in the same package (Test2) but I only want to see the dup part number that are in both packages.
DUP represents duplicate
#### represent a part number
xxxxx represents the package name that the part is in.
My dilemma is lots of time the part number might be used twice in one package and only once in another package...i.e.:
But I want a column that I can filter and see all three...
DUP-1234-Test1
DUP-1234-Test2
DUP-1234-Test2
I had another column where I used COUNTIF to identify the duplicates, but I have lots of part numbers in the same package (Test2) but I only want to see the dup part number that are in both packages.
Last edited:
