View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Popey Popey is offline
external usenet poster
 
Posts: 16
Default Counting Occurences In A Column

Hi

Here's one for you Excel forumla wizards:

Using Excel 2007 -

I have a list of customer names in Column C of a customer database I have
created, some names are repeated as they are frequent customers. Is there a
(hopefully simple) formula that would automatically search column C and tell
me how many times each customer has appeared in that column, thereby allowing
me to readily see which customers return the most?

Very many thanks.