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