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
Quote:
Originally Posted by Mazzaropi
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)
--------------------------------------------------
|