wrote in message
...

On Thursday, March 21, 2013 5:41:39 PM UTC-7, wabbleknee wrote:
I have a column of peoples names. What I want to do is count the number
of

visits, list the clients name and total of visits for a specified period.
#

of clients ~500 month. Appreciate some guidance. Tx



i.e. (column e)

Jones, bill

jones, bill

smith, bob

Jones, bill

smith, ann



Desired results;



jones, bill 3

smith, bob 1

smith, ann 1

Try =E1&" "&COUNTIF(D1:D5,E1)

Where E1 has the name you choose to lookup and count (Jones, Bill etc) and
D1:D5is the list of folks.

Regards,
Howard

I understand how I could look up each name, but that would take hours and
hours, I am talking 500+ per month. What I was looking for was to be able
to scan the name column and print out unique names, and the count of that
unique name(s), without entering the search name.