Originally Posted by aalok

hi,
i have a spreadsheet which has a column that has dates from the 1st to the 31st of one month.

the spreadsheet has 11000 rows of data and i want to be able to say how many rows i have for each date.

example

row 1 -- 6/01/10
row 2 -- 6/01/10
.
.
.
.
row 20 -- 6/02/10
.
.
.
.
row 11000 -- 6/30/10

i want my output in the following format

date number of rows
6/01/10
6/02/10
..
.
.
6/30/10


Can anyone please help.

Thanks