grouping

I need an array function that works much like the column grouping function of a pivot table. For example: Referencing the list of items below... <tbody> Mary Mary Bob John John John </tbody> ...is there an array formula that would return the three distinct items ("Bob", "Mary"...

Without using a pivot table, because I'm only dealing with ~3,000 tenure-related records, is there an efficient way to group and/or filter (on the following without doing nested IF's? I'd like to have groups of (0 - 5 years, 5 - 10 years, etc.). Note: I have Power Pivot but I don't think it...

sorry for poor title! If i have Names in column A, then a Rating (1, 2 or 3) in column B....Lets say JOHN DOE is listed in column A, 8 times. I want to find out if all his ratings are the same in column B. Column C just needs to indicate that not all JOHN DOE's ratings match. Hopefully...

Hi Guys, Probably something simple, I have a number of tables and when I group them to series, if a row is added to any table the group remians. For example If I group Row 2 and 3 in table1 and add a new row(4), the group stays on 2/3. Is there a way to make the grouping follow the table...

My question: Where or how do I turn on the setting that will automatically create a new variable in the field list when I change how a pivot table is grouped in excel 2013? The problem: If I have multiple pivot tables from the same data source and I change how something is grouped then all...

I have a pivot table that seems to be gathering a bunch of dates into a greater than field. I've had this before but its usually just todays date that's the greater than value but this one is >05/09/2017 so theres nearly 2 weeks of data bundled into this value. I've tried refreshing the data...

is there a way to retain custom grouping in pivot table every now and then the data headers and values are being changed and new rows are added in the source data then the pivot table layout changes when ever the values are refreshed. i would like to know in detail whether the custom...

Hello, In our Excel table, let's say we have column B and column C. We would to group column B into one group, and column C into another group. So we click on column B and choose "Group" and it does the trick. Next, we click on column C and choose "Group", but now column "C" is grouped together...

I used custom format ([$-1970000]B2dd mmmm yyyy;@) to be able to enter the date value in Hijri Calendar, but when i use pivot table and try to group according to date, i found the date grouping is based on Gregorian Calendar. My question is; possibility of grouping date based on Hijri calendar...

Hi all, I have a large document containing a list of researchers, their expertise and the companies they work with. Each researcher has a different number of expertise and companies they work with. I am trying to group all the rows from one academic together and link them to that specific...

Dear all Excel Professionals, I am a total newbie to excel and wants to know if it is possible to have a auto generator for the grouping. I have 8 games, max. for 36pax (sometimes will be fewer to 18pax). I will have 4 groups to do the same game at the same time. I hope to make a auto...

I've created a rule in conditional formatting to format rows based on duplicate values using this formula: =ISODD(SUMPRODUCT(1/COUNTIF($A$1:$A2,$A$1:$A2))) Which works nice but excel freezes when scrolling through my sheet. Is there another way which is 'lighter'? Or VBA perhaps?

Hello! I have a sheet full of data. In column A there are many rows with blank cells. I'd like to collapse (group) them up to the previous row that contains data. The goal is to have all data showing where there is a value in Column A. The user could then click the "+" next to that row and...

Can anyone help me with a VBA script to automatically merge cells that are lettered down A,B,C, etc. in 1 single column? For example, letter "A" might possess only 2 cells, but letter "B" could carry 2 or more, etc. Is there a way to automatically merge each "lettered" group of cells...

Hi all, any help is appreciated Basically I would like to get a large amount records from this format (example) - <tbody> Names Addresses AA xxx1 RR xxx1 CC xxx1 DD xxx1 EE xxx2 FF xxx2 GG xxx3 HH xxx3 KK xxx3 JJ xxx4 </tbody> To this - <tbody> Name 1 Name 2 Name 3...

Goal: To use a macro to group my data based on the detail information being indented. I have the following in Column A of a worksheet: Item description detail detail detail Item description detail detail detail detail detail detail Variables: The number of Item...

Hi All, I'm trying to create a monthly report for my business, but facing some issue sorting the spread sheet. As you can see in the image, I have multiple rows of sales information belongs to each individual. https://www.dropbox.com/s/lklc8t606taguvz/a1.png?dl=0 When I try to sort the...

Guys / Gals, The VBA Editor typically groups the code by type: - Worksheets - Forms - Modules - Class - Et Cetera. My explorer just lost this grouping and all items are now sorted strictly alphabetically. How can I restore the grouping by type? Thank you, John In Annapolis, MD

I have a two sets of data from two different subsidiaries that serve the same market. The newer subsidiary "bought" customers from the old one, but the old subsidiary still services the market with those products that still remain outside of the capability of the new subsidiary. Easy, right...

Hi All Very minor issue but curious to know if there's a way round it. I have some code which generates a report and emails it to the recipients, part of this code is applying grouping on certain data within the report. I've noticed that when the user expands the group (based on Rows rather...