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.


--
philcassell
------------------------------------------------------------------------
philcassell's Profile: http://www.excelforum.com/member.php...o&userid=36520
View this thread: http://www.excelforum.com/showthread...hreadid=562737