Occurrences of a date in a column

  • Thread starter Thread starter Phyllis Blans
  • Start date Start date
P

Phyllis Blans

Hi all,

I'm not a very good Excel user (yet!) and after going through the
topics, I don't think I've found what I need, so I'll ask the question.

I have one column of data which is dates:

Col A
1/17/05
1/17/05
1/17/05
1/18/05
1/18/05
1/19/05
1/20/05
1/20/05
1/20/05
1/20/05

How can I get a count that shows:

1/17/05: 3 occurrences
1/18/05: 2 occurrences
1/19/05: 1 occurrence
1/20/05: 4 occurrences

thanks for your help!
Phyl
 
To get a distinct list, select the dates, do data>filter>advanced filter,
select unique records only and copy to another location

when you have your unique dates, use countif

=COUNTIF($A$2:$A$100,D2)

copy down
where A2:A100 is the full list of dates and D2 the first unique date

you can also use a pivot table, select the dates, do data>pivot table pivot
chart report,
click next, click next, click layout, drag the dates header to the Row, then
drag it again to the data,
click finish. The latter method is probably easier
 
Back
Top