grouping rows

  1. D

    Grouping rows in pairs

    Hi! I want to be able to group row 1 and 2, 3 and 4, 5 and 6 and so on. I have information on the first row of the pairs and want to sort the pairs according to that information and it is important that the second row of the pairs don't get dislocated when sorting. Does anyone know how to do...
  2. A

    Group rows based on a cell value

    Hi everyone, I am new to macros, and now I'm facing a problem, where I would need your suggestions. I need to group rows in 3 levels, on first level we should only see manufacturers, on 2nd brands and on 3rd items. I thought it would be easier to group it based on a value in cell A, and based...
  3. L

    Macro needed to group data based on column location with multiple rollups

    This is going to be hard to explain, but here goes. For any of you that are familiar with PeopleSoft, chartfields are organized into "trees". Think of this as basically a file structure where you have a parent folder (node) and under that folder you have either additional folders or detail...
  4. E

    Grouping of rows does'nt work in Excel 2007

    Dear reader, In my workbook I have trouble grouping rows in one of the worksheets. I have read a view of the postings in this forum and checked my options and they are now OK. Can anyone help me? I have tried several times and every time the program stops responding when I try to group my...
  5. P

    Script to group pairs of rows

    I need help please. I need to group pairs of rows in my excel (2010) spreadsheet. The first row are headings. I have multiple columns of data. The even rows have values in every column (A-H). The odd rows have a value in only one column G. In column G in the even row, is a barcode. In the odd...
  6. J

    Grouping rows based on common values

    Hello :) I have stuggled with this one for ages. I'm just past beginner stage of VBA, and I can't find anything in the manuals or online. Here is my question : I have a sheet like this, with one row per client, with codes and dates : <TBODY> Client Code1 Code2 Code3 Code4 Date...
  7. N

    Grouping rows, permutations

    Hi to everyone on this forum a few days ago I was looking for a code to generate 19683 permutations out of three letters abc and I found it here on mrexcel board RUGILA gave it to another member I only changed the letters anyway, I'm now trying to get another code to group all permutations...

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