LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default count calls by dates

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Dates between Dates exclude Text Ken Excel Discussion (Misc queries) 3 April 8th 09 07:59 PM
How to use count for calls per hour kg New Users to Excel 1 September 20th 08 03:56 PM
Calls per Day Nate Excel Discussion (Misc queries) 1 September 17th 08 09:59 PM
I want to count the total Number of dates between two dates How? seshu Excel Worksheet Functions 3 February 7th 08 05:41 PM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 03:54 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"