groupeddata

  1. C

    Pivot Table Subtotal on Grouped Data

    Hi all, I have a pivot table where I've got row labels listed as Assessor Name, Fiscal Year, and Quarters. I've collapsed Quarters into Fiscal year so all that appears is as below. What I need to represent in red below is what percentage of the total of FY1314 does the blue figure represent...
  2. B

    Function / VBA Code for Grouped Columns in Excel 2013

    Hi everyone, I have a pretty large database for which I'm trying to write a function. For each row in my database, there are numerous columns that each row item is "tagged too." However, not all of the columns are showing, because they are grouped together (and you have to expand all groups to...
  3. M

    Can I protect formalas and have grouped data

    Is there any way you can have protected formula's but let grouped data open and shut? Once a sheet it protected and the formula's are locked, im unable to open gruped data, is there a way to lock formulas, and be able to open and close grouped data without having to protect/unprotect the sheet...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top