grouped

It would be easier to show you an example, but I cannot post attachments... I am trying to create a chart with grouped, floating bars. In my example, I have 4 groups that each have 3 floating bars (some are crossing the x-axis). This is the most difficult chart formatting I have attempted yet...

Hi, I'm someone can help. I have had to group rows of data using the group data function. However, I have a filter on line 4 as below and every time I use this filter and then remove the filter it expands all of the grouped data. Is there a way to prevent the grouped data from expanding...

I know how to sort by color for a column. What I want is to sort a column by multiple colors, i.e. just group the colors together. They dont have to be in any specific order, just grouped together. Is there a macro or code I can write to do this? Thanks

Good Day, I wish to return either "R" or "NR" in a given column. This needs to be done on a file level (Column "FILE_REF"), so the function needs to be performed per file. If column "READY1" contains ONLY "R" values for a specific FILE_REF, then it must return "R" to ALL rows containing that...

I have tabs that already have grouping assigned to certain columns. I would like to create two macro buttons, one that will go through each tab and group, and another that will ungroup. Each tab has multiple groups of columns that are grouped. The purpose is so that when a user prints a...

Hello! Is any other method to insert at a time a comment in the same cell (e.g. A1, B5, F10 etc.) from some grouped sheets of an Excel workbook? If I try to do it in the classic mode, after having grouped the respective sheets all the icons from the Comments section of the Review windows are...

Hi all, I am having trouble using Macro which is my first time using it. Essentially to keep it simple on 'Sheet 1' I have personal data with grouped data so info can be hidden/ displayed on demand. I have a list of surnames and there personal details listed below but grouped so it remains...

I have a sorted worksheet that includes Outline/Grouped rows as well as single rows. As I add new rows and resort the worksheet, the previously grouped row NUMBERS remain grouped, however the rows previously grouped are often shifted out of that group. When I group rows I add a new row below...

Hi I am looking for some VBA code to collapse a specific range of grouped cells (row 7 on my sheet) whilst leaving other ranges of grouped cells (rows 37 to 51 on my sheet) expanded. I have tried hunting forums but can only find code to collapse all cells (somthing like...

I have a csv file that contains columns with dates, when filtering it they are not grouped, but when opening that same file on another computer if it is grouped. To solve it, verify that it activates the option "Group dates in the AutoFilter Menu", in addition to validate the language and format...

I am wondering if its possible to change the text orientation when a cells that are grouped are minimized/maximized. Basically I have merged several vertical cells and have the text orientation for those cells as "90" degrees. Now these rows are grouped, and if I minimize the grouping, the text...

When group level 2s in level 1 thing in video happens -(When last row of level 1 is included in a level 2 hierchy. Grouped data should be in level 2 but its beyond level 3 as in the video in attachment) When all level 2 headers are selected and grouped for level 1 thing in image happens-

I have a MS-Excel Workbook with 100+ Sheets. I need come up with a dash board like, fetching the information based on Column, C D and Column E and to have a count based on Column E, grouped by per Sheet and all the sheets Column C Label is ''RACK Column D Label is 'Device No.' Column E...

Hi I am reading this article https://www.wikihow.com/Ungroup-in-Excel about ungrouping sheets and it says "or press <kbd class="keyboard-key nowrap" style="border-width: 3px; border-style: outset; border-color: rgb(219, 219, 219) rgb(243, 243, 243) rgb(243, 243, 243) rgb(219, 219, 219); padding...

Hi Excel Experts, Below is link of my sheet, in which I would like to allow user to open or close grouped columns. Is there any solution, which does not involve VBA. Any thing simplest????...please) ...Please note that sheet will be password protected...

When added a filter to a column in my sheet. When I click "clear filter" to reveal all rows, the rows I had hidden by using the group function - ungroup. How can I prevent this and keep the grouped rows hidden regardless of the filtering?

When I clear a column filter to reveal all rows of a sheet, the rows I had hidden by using the group function - ungroup. How can I avoid this and keep the grouped rows hidden regardless of the filtering?

Hi all, Anyone know how to create a histogram for continuous data? I want an x axis that begins at 0, then half a unit to the right i need it to start at 150 and finish at 200 at 10 unit intervals (classes). Between each of these 10 unit intervals must be a column (no gaps between columns)...

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"...

Hi all, I have a problem that I am hoping someone can help me out with. I have a large excel document that I keep am using to keep track of customer information. One of sheet of the workbook I have a list of all customers including name, order numbers, start/end dates, then information on ramp...