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

Have you used a Pivot table for this?

Asobi Wa Owari Da ----- just tried Pivot Tables and works like a charm.

thanks for the hint !!!!

appreciated..

A

Dear aalok, Good Evening.

Suppose your dates are on A colunm. (A1 to A11000).
Your Results table will start on C1.
Try this one:

.............A............B.......C..............D .....................
00001..6/01/10............6/01/10..=COUNTIF(A1:A11000,"=06/01/2010")
00002..6/01/10............6/02/10..=COUNTIF(A1:A11000,"=06/02/2010")
00003..6/02/10............6/03/10..=COUNTIF(A1:A11000,"=06/03/2010")
00004..6/03/10............6/04/10..=COUNTIF(A1:A11000,"=06/04/2010")
00005..6/03/10............6/05/10..=COUNTIF(A1:A11000,"=06/05/2010")
.
11000..6/31/10..........


I hope it can help you.

Best Regards,

Mazzaropi
-------------------
Daquí das bandas das Minas Gerais, Brazil
(Marcilio Lobão)


--------------------------------------------------

Mazzaropi,
thanks for the information....
i tried it and it worked perfectly.
however i have to run this against a spreadsheet every quarter so was wondering if there is a way to automate the process wherein i do not have to change the dates manually in each countif statement.

Is there anyway to do that cos i now have 60000 records and 90 days to go through...
Also i need to come up with how many calls within a day were "direct" and how many were "Intnl"

thanks

Aalok

sample of the data i have is as follows
Date DESCRIPTION
060210 DIRECT
060310 DIRECT
060310 Intnl
060410 DIRECT
060410 DIRECT
060410 DIRECT
060510 Intnl
060610 DIRECT
060710 DIRECT
060710 DIRECT
060710 DIRECT
060710 Intnl
060810 DIRECT
060910 DIRECT
061010 DIRECT
061010 DIRECT
061010 DIRECT
061110 DIRECT
061210 Intnl
061310 DIRECT
061310 DIRECT
061310 DIRECT

Thanks

A