This project has moved and is read-only. For the latest updates, please go here.


Jun 29, 2011 at 8:26 AM

Can anyone guide me on how to use grouping/ungrouping feature..?? A code snippet would be helpful....

Jun 30, 2011 at 7:55 PM

Have a look at sample 6

Jul 5, 2011 at 3:16 PM

Thanks for the reply. But I am unable to use the code from sample6(i was not able to find any grouping functions). I just need to group a few rows together before saving the worksheet.

Jan 4, 2012 at 3:22 PM

Is there a solution for the above question. I want to use the subtotal function in Excel to display a group of values.

Sample Scenario:

State cities Counties Hospitals Gas Stations

I want to group by State and City to get the Hospitals and Gas stations. Counts should be displayed at the each subsection.

Many thanks.

Jan 4, 2012 at 3:47 PM

Take a look at this thread, maybe can help you.