Counting number of occurences of a date

[cranfss]

I have a column A with:
11/2/2005
11/2/2005
11/3/2005
11/3/2005
11/8/2005
11/8/2005

How do I count the number of occurences of each date so that is looks like this:

11/2/2005
11/2/2005 2
11/3/2005
11/3/2005 2
11/8/2005
11/8/2005
11/8/2005 3

Thanks.

 

[eliW]

Hi

This what I get with a most simple Pivot table:
DATE in Row field and Count of DATE in DATA field.

Eli

Book1
	A	B	C	D	E
1	DATE
2	11/02/2005
3	11/02/2005		CountofDATE
4	11/03/2005		DATE	Total
5	11/03/2005		11/02/2005	2
6	11/08/2005		11/03/2005	2
7	11/08/2005		11/08/2005	2
8			GrandTotal	6
9
גיליון1

 

[lenze]

Note, you can also group your dates by days (7 days for a week), Months, or Years.Might be useful

lenze

 

[Joe4]

Let's say your data is in the range A1:A7, then put this formula in B1 and copy down for all rows:

=IF(A1<>A2,COUNTIF(A$1:A$7,A1),"")

 

[cranfss]

Thanks for the replies!

Eli, I like the pivot table but I am unable to access any cell except a1. Can you email the spreadsheet to me?

Thanks.

 

[eliW]

my pleasure! but you forgot to mention your Email address!

 

[lenze]

I placed a sample file here

http://www.box.net/public/glcx57nomi

lenze

 

[eliW]

Thank you Lenze