Problem with a function

[kvemperor]

I have 2 shops and I have made a table of what I have sold in each shop.In the cell M6 I have put the let function combined with others so I have both the shops inventory in one. the results have spread across .if you check at the end at the bottom ,from cell M180, it gives me an error. What have I done wrong?
I have excel version 2021 so this can be sold,I believe, with excel version 2021 or excel 365
Thank you in advance

[AliGW]

For information, Excel 2021 does NOT have all the new Excel 365 functions. It has only a few of them.

I think this is what you need:

Please Login or Register  to view this content.

[kvemperor]

Hello from Greece
Thank you very much for fixing my sheet first of all.Can you tel me please what i have done wrong?
Also ,because the shops are in table form, normally if put new values in the tables ,the cells on the right(that are related with the function that you fixed),will get updated,correct?
i know that excel 365 is more advanced than excel 2021.

[AliGW]

Can you tel me please what i have done wrong?

I highlighted in red where you had made the error - if you try to pull unique lists from individual columns, they won't match up any more. You have to compile your table and then extract unique rows based on ALL fields (columns).

Also ,because the shops are in table form, normally if put new values in the tables ,the cells on the right(that are related with the function that you fixed),will get updated,correct?

Sorry - I have NO IDEA what this is asking, however it is up to YOU to test any solutions offered here. You told us that your formula wasn't working but you failed to tell us what your expectations were - you left us to guess - so how can we test anything???

Make a few changes and check that the solution I offered is doing what you want. If not, then explain in DETAIL what should be happeneing.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.