Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping data in excel 2007
I have data in following format
Date time doc no item batch (dd-mm-yyyy) (hh:mm:ss) 10-03-2009 15.33.24 1548526 abc aghdsa 10-03-2009 15.33.25 1548556 abc aghdsa 10-03-2009 15.33.25 1548556 xvd adddsa 10-03-2009 15.33.25 1548556 xyz wwhdsa 10-03-2009 15.33.25 1548556 def aghdjh .. .. and so on for 24 hrs which is data of around 40 to 50K rows. I need to segregate the data and know which time slot has max activity. Time slot can be 15 min. In above example, doc no 1548556 should be counted only once. Pl advise VBA approach or suitable formula for the same. Regards, Madiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping above in Excel 2007 | Excel Worksheet Functions | |||
Grouping Rows in Excel 2007 | Excel Discussion (Misc queries) | |||
How do I change the Data Grouping options in Excel 2007? | Excel Discussion (Misc queries) | |||
Need help with grouping in Excel 2007 | Excel Worksheet Functions | |||
Need help with grouping in Excel 2007 | Excel Worksheet Functions |