lukaszzyla
New Member
- Joined
- Nov 9, 2023
- Messages
- 2
- Office Version
- 2021
- 2019
- Platform
- Windows
Sounds mysterious but maybe pictures will help:
I have a range of text strings (list of products) - 100 - 500 different names:
this is a list of products that we need to manufacture. Each one of them has unique name (column A: B.13 B.14 etc) , we need different quantity of each of those (column B) and each one of them has different area (column D) we need a way to track down number of pieces and calculate area of every type manufactured (there might be more than one piece needed)
Then, we are manfactuing few of them every day and we manually write down their names:
Because it lasts months usually and we need to know exactly how many of which we do have, and how many more are left for manufacturing, and how many have me manufactured in terms of pieces and area.
Currently we use crazy long functions that excel doesnt accept sometimes because formula exceeds 8100 letters:
to get number of pieces manufactured every day we use:
=COUNTIFS(L7:L49,list!A2:A261) from manually enetered manufactured product references (each column above is different produciton day
and to get area manufactured we use another function:
=COUNTIF(L7:L50,"N1.1")*VLOOKUP("N1.1",list!$A$2:$W$300,3,0)
but they get crazily long if the list form first picture has a lot of unique names/types:
(this is just a part)
What I would like to achieve is:
check daily manufacturing list AGAINST full list of types and calculate area of daily manufactured products every day.
Anyone that has an idea how to deal with it?
I have a range of text strings (list of products) - 100 - 500 different names:
this is a list of products that we need to manufacture. Each one of them has unique name (column A: B.13 B.14 etc) , we need different quantity of each of those (column B) and each one of them has different area (column D) we need a way to track down number of pieces and calculate area of every type manufactured (there might be more than one piece needed)
Then, we are manfactuing few of them every day and we manually write down their names:
Because it lasts months usually and we need to know exactly how many of which we do have, and how many more are left for manufacturing, and how many have me manufactured in terms of pieces and area.
Currently we use crazy long functions that excel doesnt accept sometimes because formula exceeds 8100 letters:
to get number of pieces manufactured every day we use:
=COUNTIFS(L7:L49,list!A2:A261) from manually enetered manufactured product references (each column above is different produciton day
and to get area manufactured we use another function:
=COUNTIF(L7:L50,"N1.1")*VLOOKUP("N1.1",list!$A$2:$W$300,3,0)
but they get crazily long if the list form first picture has a lot of unique names/types:
(this is just a part)
What I would like to achieve is:
check daily manufacturing list AGAINST full list of types and calculate area of daily manufactured products every day.
Anyone that has an idea how to deal with it?