Thread: Countif.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
 
Posts: 90
Default Countif.

I want count the ammount of times that a name comes up in a given day, for
example,

A B
1 July 20, 2009 John Doe
2 July 20, 2009 Jane Doe
3 July 28, 2009 John Doe
4 July 28, 2009 John Doe
5 July 28, 2009 Jane Doe
6 July 28, 2009 Jane Doe
7 July 28, 2009 Jane Doe

On July 20, 2009
John Doe - 1
Jane Doe - 1

On July 28, 2009,
John Doe - 2
Jane Doe - 3


What function can I use??