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...
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.
Intercompany Recs Bulgaria # 0059.xlsb
Intercompany Recs Bulgaria ∣ 0059 - Copy.xlsb
Intercompany Recs Bulgaria ☠ 0059.xlsb
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...