grouping

I am building a model where when regions will be selected via a filter in a slicer but need it to change which field is brought in depending on which region is selected. In other words, I want the slicer to stay so that you can easily select the region, but I need the column headers in the pivot...

I have a structured table, and there are three different columns representing a monthly period in the format YYYYMM (201809). The first is system generated, the second column is a manually input override period, and the third is a formula that takes the latest of the two periods. When I click on...

I am trying to write a macro to group my project schedule in Excel based on the number of periods in the WBS column. This is not working, but I feel as though I am close. Sub Group_1() Dim cell As Range Dim WorkRng As Range Rows.ClearOutline On Error Resume Next xTitleId = "Grouping" Set...

Hi There, I wonder if someone can help me? I have a series of data (~700 rows, 5 columns) that I am looking to allocate into 5 groups using a random function and based on a series of rules / criteria that I would like to apply. I wondering if there is a simple formula that I can apply to the...

Need Assistance how to associate combination of Company and location to apppropriate company using the below matrix please help. <colgroup><col span="2"><col></colgroup><tbody> Grouping Matrix Group Name Company Location XXX 100 000,155,200,208,209,210,211,212,213...

Hi All, I'm sitting behind a corporate firewall so posting pictures is not possible, so i'll counjour the image with words and copy/paste....maybe. Oh, I'm using Excel 2016. I hold a data table, these headings, all in their own column. (This is a sample, my actual data table is 23 columns...

Hi Mr. Excel, I need help, as my lead challenge me but I can't do it in any means. He only wants me to use a formula in column B. Only FORMULA. Col A: a b b a a b c c c Col B: Answer must me in group unique value 1 2 2 1 1 2 3 3 3 Please help.

Issue summary When you change from one level of ROW Grouping to another (drilling in or out) - the filter selection remains the same, but is not reflecting in the data that shows. You have to click back into the filter (change nothing) and then it will display Issue Detail Data - Autofilter...

This will be easy peasy for people in here but i need a hand with my wee bit of code which groups or ungroups rows. Basically i want the VBA to establish if the sheet grouping is 1 then make it 2 but then stop. If the same button is pressed again the macro will see that grouping is 2 so then...

Hi Everyone, I am creating a sheet in which information is inputted into it. I have a series of four rows which information is inputted into. Then these 4 rows are copied downwards 12 times. However, based on the job, not all 12 fields are used, so as a result, I would like to hide these from...

Do i have to ungroup and then regroup with new data or is there a way to add a new record to a already established pivot table grouping?

Hi All, How do I incorporate this? If column called Groupings = "Big" and the column "Sub Grouping" does not contain "Tasks" then return "Investment" If column "Groupings" = "GDE" or "Tasks" return "Fail" Everyone else return "Other".

I'm trying to recreate an existing pivot table and in the Rows window there's a sigma symbol on the 'tile' with the word Values on it. This tile is somehow associated with all of the sums shown in the Values window. If the tile is removed from the Rows window all items in the Values window are...

In excel, when you group: rows, data grouping levels are shown in a frame to the left of row numbers columns, data grouping levels are shown in a frame above column letters Is there a way to determine the width of the frame added to excels window?

Hi, I have two columns in excel SizeB SizeC 200-500 A 200-500 A 200-500 B 5000-6000 A Is there a way I can count how many A's there are for 200-500, how many B there are for 200-500. So grouping the size column in excel. Thanks.

Hello All, I'm new here, so please forgive my naivety. I've watched dozens of videos in an effort to resolve my issue, with no luck. So, I'm reaching out to the experts. Issue: I work for a printing company. We want to group art across the paper based on label quantities in the most efficient...

Is there a way to use a macro to open or close grouping instead of pressing the 1 or 2 or + / - on the left? I would like a button as part of my menu system to recreate? Thanks,

Hi, I've calculated difference between dates in hours - so if it was 2 days it will show 48 hours and so on, but pivot table grouping doesn't allow me to set group above 24h limit... Any ideas how to remove this limit? Otherwise I will have brackets from 0 to 23...

Like the title. I was having trouble grouping after checking the box to add data to Data Model (I wanted to use the Distinct Count not regular count), and came on this article and comment that said it wasn't possible to group in your pivot table if this box was checked...

I have a report that is grouped by "expression". Their are 4 groupings and each group has a number from 1 to 4. the first grouping is grouped by the expression "=4". The second grouping is grouped on the expression "=2". The 3rd grouping, the expression is "=3" and the 4th grouping is "=1"...