Calculating where there are duplicates.

[brummingham]

Thanks for taking time to read this.

So in column N I have a list of names and in column Z I have an option (this this case a colour - red, yellow, blue)

My list of names is for a month period. I want to work out how how people pick red for example. BUT ONLY COUNT THE AMOUNT OF PEOPLE WHO HAVE CHOSE RED FOR THAT ONCE

example

name
Bob
Kelly
Bob
Allen

Colour
Red
Blue
Red
Yellow

Using above example I will return the value one for red.

I have three colours covering each colour. So using that example red will show as 1 the others zero.

[JohnTopley]

Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[brummingham]

Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Due to confidentiality I can’t. But no problem