grouping

  1. V

    Is it possible to assign grouped rows to a 'Parent' row for filtering purposes?

    Haven't been able to find anything searching online. I am looking to understand if it is possible to assign grouped rows to the row above the group so that when applying filters to the data only the non grouped rows get moved around, bringing the group assigned to them to the next position in...
  2. A

    Creating An 'Overlap' checker

    Hey, I need a way to calculate overlap between Groups but not within the same group. I need to make a template where a user can input the group name and the Numbers associate and have a easy checker to see if there is any overlap between the groups. Ideally there is a Button which runs a Macro...
  3. B

    Autogroup not working in pivot

    I have below lines of code whare i am trying to group the dates in to month. below code is not grouping and at the same time not throwing any error. can someone help me with this. With ActiveSheet.PivotTables("Report").PivotFields("WEEK_END_DATE") .Orientation = xlColumnField...
  4. J

    Grouping by periods - Specific Scenario - Formula/Workaround

    Hi guys, Wonder if any of you have encountered a similar scenario: I've got a table similar to the following one, with a few hundreds of different entities where each of them have its own specific "length". Don't know how exactly explain it but I would like to group the Q by buckets of...
  5. L

    VBA Excel, group rows and perform an action for each group

    Hello! I have an excel like this: So I have column A, I want column B to complete automatically. I though that by entering a blank row between groups it will be easier to separate groups. So it will go down the column A and for each not empty row it will write Iph in column B, when it finds...
  6. J

    Grouping Pivot Table and Slicers NOT working

    I have been trying to figure this out all day: I am building a dashboard, and I have everything in a summary tab (in a table) to pull for pivots. The dates do not seem to be recognized as dates when I try to use a pivot to group by date. I have tried text to columns, and formatting cells. I...
  7. J

    Advanced Transpose and/or grouping help

    I need help, I'm on a MAC and don't know how to use VBA's. Previously I would have used MS Access, but.... Mac! Here is what my data looks like: PDP URL IMAGE URL IMAGE ALT TEXT abc.com/page1.html abc.com/images/banana.jpg Banana abc.com/page1.html abc.com/images/apple.jpg Apple...
  8. V

    Scheduling Sheet

    Anyone able to provide some quick help? I have a worksheet I am working with to schedule fabrication. I need two macros to format the sheet and a background process. Macro 1: Button Labeled "Fab Start"; sorts by Column I "Planned Start" oldest to newest creates...
  9. C

    Grouping Rows

    Hi all, I want to group rows in blocks of 2 rows at a time. For example...row 1 & 2 would be a group. row 3 & 4 would be a group. so on and so forth. I want to use the 1 & 2 button to open and collapse the groups. I had it before but can't for the life of me remember how to do it again. I have...
  10. C

    Re: Number Selection - Extension

    Re: Number Selection - Extension Hi All, Extending from another thread posted Re: Number SelectionOct 24th, 2019 I am looking to analyze multiple alternate groupsizes combinations upon a Number Table and performing a similar type of ROW andCOLUMN analysis undertaken in that thread. Please see...
  11. L

    grouping sheets and inserting a picture/shape

    Hi I wanted group several sheets and then insert a picture or shape in one sheet and hoping it will appear on all grouped sheets but when I group sheets, insert picture or shapes options are grayed out. Is that by design? Thank you.
  12. J

    Pivot table grouping into months/ years not working

    hello please can someone help me. I am using Excel 2016 and in my pivot table, I tried to group my date rows (example 11/12/2018) into months or years. However when I click on 'Group Selection', it automatically assigns Group 1, rather than giving me options to sort into years and months. I...
  13. M

    Grouping dates from the past

    Hi, If i list of historical dates from the past in Column A and I want to identify as either "<6 months from today", "6-11 months from today", or "12+ months from today", how should I write the formula? I am having trouble. Thanks!
  14. S

    VBA Count and paste value

    Hi im trying to find out how to count the numbers in each group, using macro instead of formula, the group go on for as many as needed, i want it so that it does number part for me...once i have filed out group and name... <tbody> Group Name Number G1 ASJ 2 ATT G2 AMM 4 MKK...
  15. B

    Group Data with Like Content

    I have a list of URLs that I am determining which has the best page value. Many of these urls begin with the same data. I'd like to group these like urls together and have the sum of the page value on the same rows to to be added. The data is structured as Column A...
  16. D

    Subgroup and list top 2

    How can I go about creating a subgroup listing of the top 2 The data Name a a b b b c c d d d d output to starting range("G15") Top 2 D = 4 B = 3 Even the simple stuff sometimes seams difficult
  17. P

    Macro to cycle through dropdown, paste output to tab by grouping

    Hello, Hoping someone can point me towards a solution on the following: In tab "model", I have a model that outputs data in cells B2:G104. This is based on a dropdown selection in cell I5 that pulls from a list in tab "List by SL", cells B2:478. Cell I8 in the tab "model" is an index match...
  18. E

    Macro keeps re-protecting sheet without all of my lock preferences

    I need a macro to run upon opening excel that allows groups to expand and collapse while a sheet is protected. I am using the code below and it works, the issue is that when it re-protects my sheet is it only doing the first two defaulted lock preferences, "Allow all users of this worksheet to...
  19. J

    Form Control Grouping Greyed Out

    Hi all, I'm creating a set of checkboxes for a multi-series chart so users can select which series to display. I'm trying to group them into a groupbox but the option is greyed out/disabled: I can create the Group Box via the Insert option on the Developer Tab I can create and format my...
  20. F

    VBA With statement: How to copy grouped items?

    Hi, I have previously created a chart and copied it to another sheet. But now I have added a text box and grouped the text box and chart together (not in VBA). I want to be able to copy the group to another sheet as a picture. I believe instead of "Chart" it's "Shape" in VBA. But I don't know...

Watch MrExcel Video

This Week's Hot Topics

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
Top