View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wabbleknee wabbleknee is offline
external usenet poster
 
Posts: 31
Default counting repeats.

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