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)
--------------------------------------------------
Quote:
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
|