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 isn't 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
I should note there are over hundreds of rows of data which has a number of unique H values in that first "column" Any assistance on this is greatly appreciated
For example and I would attach an actual example but it for whatever reason isn't 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
I should note there are over hundreds of rows of data which has a number of unique H values in that first "column" Any assistance on this is greatly appreciated