Hello, I am trying to count the number of times "positive" occurs however the positive could occur duplicate times for a unique value and I only want to count the positive the one time in that instance.
For example and I would attach an actual example but it for whatever reason isnt working so I hope this will do.
H235 Negative
HA260 Negative
H235 Positive
H789 Positive
HA852 Negative
HA951 Negative
HA951 Negative
HA951 Positive
H235 Positive
I should only have 3 "positives" as H235 & HA951 has a duplicate positive
Any assistance on this is greatly appreciated
Bookmarks