Counting Enteries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=SUM(--(FREQUENCY(IF(A1:A100="Billy",MATCH(B1:B100,B1:B100,0)),ROW(INDIRECT(
"1:"&ROWS(B1:B100))))>0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top