#### UseLessFuel

##### New Member

- Joined
- Dec 22, 2012

- Messages
- 37

Hello.

I have a column of numerical data (Column C) which holds various groups of contiguous numbers separated by (truly) blank cells. The size of each group of contiguous numbers varies from only one, up to 200 or more. I would like to group Column C from low-to-high group size, along with the corresponding timestamp data held in Column B. I would also like to get the Count and Sum of each group of contiguous cells. Hope this is clear enough to go on. I am familiar with pivot tables, and some VBA (usually gained from this site!).

I have a column of numerical data (Column C) which holds various groups of contiguous numbers separated by (truly) blank cells. The size of each group of contiguous numbers varies from only one, up to 200 or more. I would like to group Column C from low-to-high group size, along with the corresponding timestamp data held in Column B. I would also like to get the Count and Sum of each group of contiguous cells. Hope this is clear enough to go on. I am familiar with pivot tables, and some VBA (usually gained from this site!).

Last edited: