Hello All,

I am not too sure how to explain it so I will provide an example.

Column C represents how many times that name was shown. Is there an easy way to do this or a simple formula? I appreciate the help

A B C
Phil Phil 3
Phil Bob 2
Phil Anne 4
Bob John 2
Bob
Anne
Anne
Anne
Anne
John
John


Peace

Phil C.