Hi All,
I am after a formula which only counts 1 "Yes" response from each person. Here is an example below:
example.png
Basically, I would like a forumla that counts how many times "Yes" has appeared in column B, HOWEVER it will only count 1 "Yes" vote from each person.
For example, in this picture person A has answered "Yes" twice, but I want this to only be counted as 1. Any future times person A has answered "Yes" will not be counted. The same for person B, C and D and so forth. I am after the total of this frequency, which in this example would be 4.
Is this possible?
Thank you!
Bookmarks