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