group arrange order

  1. I

    Intercompany reconciliation

    Hi I have approx 500 companies which could have a balance with each other. So in total are approx 250K combinations. I am trying to group them to see whether the balances between them are correct or not. For example AB-CD should be grouped with CD-AB. I have tried to find MATCH and INDEX...
    • ioanaa
    • Thread
    • entity excel & macro group arrange order intercompany sort and seperate data
    • Replies: 6
    • Forum: Excel Questions
  2. E

    Group or Subtotal with Total on Top

    Hi, I'm trying to create a file with a kind of drill down option... So, let's say on Row 4, I have the category and then from Row 5-10, I have the product and Row 11, I have the category and from Row 12-14, there is products...etc..etc... I was wondering if there was a way to have use the...
  3. S

    Help with macro arranging a group of cells

    Hello hello Excel board, Need some help with this one. I need for the 8 groups to be arranged in order, Group size is 3 columns X 6 rows Enter a # from 1 - 8 in top left corner (Maybe a drop down menu to choose #) Then last to arrange the 8 groups in numerical order down the page. (arrange...
  4. S

    Help with arranging a group of cells / rows / colums

    Hello hello Excel board, Need some help with this one. I need for the 8 groups to be arranged in order, Group size is 3 columns X 6 rows Enter a # from 1 - 8 in top left corner (Maybe a drop down menu to choose #) Then last to arrange the 8 groups in numerical order down the page. (arrange...

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