View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
edver
 
Posts: n/a
Default Counting Enteries


Hello,

I have two colunms. Colum A has a list of names and colum B has a list of
dates.
I would like to count the number of times a certain name name in colum A
appears with the same date once or more.

So it looks something like this (sorry don't know how this will look in the
posting)
Billy 1 April
Billy 1 April
Billy 2 April
Suzy 1 Apr
Alice 1 April

In this data set it would count 1 hit for a name which appears more than
once with the SAME date.

Any chance i can create a counter/formula for the same data?

Thank you