I would like to group 2011, 2012, 2013 , 2014, 2015 data separately to see data by year.
How do I do it as when i tried to click Group, it will group all the years together.
even when i do it separately, the group will extend to the final year - 2015.
If you are making two neighboring groups then the excel assumes ( wrongly) that it is the same group, to overcome that add additional column and then make group. You can use that column as total for the
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…