Counting Certain Unique Values

Some pieces of equipment have 2 entries (both of which will say rehab, defect, readiness ot whatever)

so if its rehab and readines does that get counted or not? do you see the problem? also how is the barcode entered in what format? i think you need to post an example
take

123456 Rehab
123456 Defect
123456
456789
456789
456789
654321 Defect
654321 Rehab

so is the count unique of above 1 or 2 ie 456789 is th only number not to have Rehab/Defect
so count is one
or 123456 is counted as one instance does not have Rehab/Defect
so count is 2