Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to take a list of dates from column E on sheet2 and have them
grouped and count the number of occurances of the dates and list them on sheet1. For example on sheet2 would be: # Description Date ================== 1 Blah blah 8/1/2007 2 Blah blah... 8/1/2007 3 Blah blab 8/9/2007 4 etc... 9/1/2007 And on sheet one it will just say: Date Count =========== 8/1/2007 2 8/9/2007 1 9/1/2007 1 ....and so on. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting count of unique dates in a list | Charts and Charting in Excel | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
I have a list of dates that I need to count based on a date range | Excel Worksheet Functions |