how to calculate quantities used using manufacturer part code

Question

Hi, i need to make sure the wording matches and then reduce the quantity on the left by the quantity on the right.&nbsp; Is there a simple way to do this please? As wording&nbsp;are not always going to be on the same line.&nbsp;&nbsp;&nbsp;&nbsp;Equipment used:&nbsp;&nbsp;Parts DescriptionManufacturer Part CodeSupplierQuantityParts DescriptionManufacturer Part CodeSupplier:apollo xpp95 addressable smoke detector55000-600APOADI50apollo xpp95 addressable smoke detector55000-600APOADIapollo xp95 manual call pointSA5900-908APOADI100apollo xp95 manual call pointSA5900-908APOADI

funtimex12 · Answer

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

hansvogelaar · Answer

funtimex12&nbsp;
I don't see a quantity on the right...

funtimex12 · Answer

HansVogelaar&nbsp;there’s one on the right the one on the left is missing but it’s Column A&nbsp;

hansvogelaar · Answer

funtimex12&nbsp;
I'd use a separate column so that you can see the original stock. See the attached workbook.

Forum Discussion

how to calculate quantities used using manufacturer part code

Share

Resources

			Equipment used:
Parts Description	Manufacturer Part Code	Supplier	Quantity	Parts Description	Manufacturer Part Code	Supplier:
apollo xpp95 addressable smoke detector	55000-600APO	ADI	50	apollo xpp95 addressable smoke detector	55000-600APO	ADI
apollo xp95 manual call point	SA5900-908APO	ADI	100	apollo xp95 manual call point	SA5900-908APO	ADI