Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Dates between Dates exclude Text | Excel Discussion (Misc queries) | |||
How to use count for calls per hour | New Users to Excel | |||
Calls per Day | Excel Discussion (Misc queries) | |||
I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions |