Hi Everyone,
This is the first time I have ever posted to an online forum after having been a long time reader! I am hoping someone is able to assist with a rather complex request. I have included the data in the attached spreadsheet as well as the output we are seeking to get. In short we need help with a formula to prepare a list of items that Shop 1 needs to transfer to Shop 2, Shop 3, Shop 4, Shop 5 etc and then a list of items Shop 2 needs to transfer to Shop1, Shop 3, Shop 4, etc.
Kind regards,
Damian
Bookmarks