View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Irelandabroad Irelandabroad is offline
external usenet poster
 
Posts: 1
Default How can I count unique values

I have a worksheet with several columns:

Column F Column K
21/10/2008 Smith
27/10/2008 Jones
28/10/2008 Smith
25/11/2008 Jones
3/12/2008 Johns
10/02/2009 Johns
2/06/2009 Ryan
4/02/2009 Ryan

I need to prepare a formula which will count the number of times each unique
name appears in a month. (i have several years of data)

Thanks