Forum Discussion
funtimex12
Oct 07, 2022Copper Contributor
how to calculate quantities used using manufacturer part code
Hi, i need to make sure the wording matches and then reduce the quantity on the left by the quantity on the right. Is there a simple way to do this please? As wording are not always going to be on t...
funtimex12
Oct 07, 2022Copper Contributor
as the manufacturer part code on the right needs to 'find' the manufacturer part code on the lef, see the quantity mount next to it and then reduce in a new column
- HansVogelaarOct 07, 2022MVP
I don't see a quantity on the right...
- funtimex12Oct 07, 2022Copper Contributor
HansVogelaar there’s one on the right the one on the left is missing but it’s Column A
- HansVogelaarOct 07, 2022MVP
I'd use a separate column so that you can see the original stock. See the attached workbook.