I would put/transfer all the names to a single column. The I would use a
Pivot Table to count the number of times each name appears. See:


http://www.contextures.com/xlPivot07.html#Unique
--
Gary's Student


"baldwin" wrote:

I am working with a large amount of information, one of which is names. I
need to know how many times a name, first and last is given in the
spreadsheet. The problem is that i have over 3000 names. Is there a way for
me to collect this information?