Hi All,
I need some help with constructing a formula.
Basically I have a three column table, one column is transfer document, one is shop and one is goods code in the shop.
What I'd like to see is what is the goods code of the same goods in the different shops. The only connection between the goods (to know that it's the same goods is the transfer document number. I'd like to create a formula that shows all combinations of the same goods amongst the shops (it can also happen that the same goods have multiple code in the same shop due to multiple transfers). Tried to do it with index/match but it gets very complicated and still I have duplicates at the end both vertically and horizontally.
Example of what I'd like to achieve:
This is where I got so far, but still some duplicates
Thank you in advance,
I need some help with constructing a formula.
Basically I have a three column table, one column is transfer document, one is shop and one is goods code in the shop.
What I'd like to see is what is the goods code of the same goods in the different shops. The only connection between the goods (to know that it's the same goods is the transfer document number. I'd like to create a formula that shows all combinations of the same goods amongst the shops (it can also happen that the same goods have multiple code in the same shop due to multiple transfers). Tried to do it with index/match but it gets very complicated and still I have duplicates at the end both vertically and horizontally.
Example of what I'd like to achieve:
This is where I got so far, but still some duplicates
Thank you in advance,