Column C represents how many times that name was shown. Is there an
easy way to do this or a simple formula?
With the list of unique names listed in B1 down
In C1, copied down: =COUNTIF(A:A,B1)
will return the indicated counts ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"philcassell" wrote:
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