intercompany

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

    # symbol is not taken as a character

    Hey, I have a bunch of files with similar names but I only need to list the ones that contain "#" character. I tried a couple of ways but no luck. File list: Intercompany Recs Bulgaria # 0059.xlsb Intercompany Recs Bulgaria ∣ 0059 - Copy.xlsb Intercompany Recs Bulgaria ☠ 0059.xlsb Intercompany...
    • wist
    • Thread
    • character hash intercompany list recs
    • Replies: 7
    • Forum: Excel Questions
  3. J

    Getting around a necessary circular reference

    I attempting to use PowerPivot to calculate our group standard cost across a number of plants globally. The trick is that often we have intercompany (inter-plant) materials whose standard cost is that of the selling plant's. The calculation of this is causing some circular references, despite me...
    • jolee217
    • Thread
    • circular dependency circular reference intercompany lookupvalue powerpivot
    • Replies: 4
    • Forum: Power Tools

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