Hello- i have an excess inventory on hand which i need to figure out which part to keep and which part to destroy.
my goal is to get a formula that will give me the desired output for the column in red font (destroy the rest). I have done a few scenarios to hopefully explain this better. As you can see i am adding (current on hand + last years inventory shipment)-keep 5 years of inventory on hand.
Thank you in advance.
<tbody>
</tbody>
my goal is to get a formula that will give me the desired output for the column in red font (destroy the rest). I have done a few scenarios to hopefully explain this better. As you can see i am adding (current on hand + last years inventory shipment)-keep 5 years of inventory on hand.
Thank you in advance.
<tbody> </tbody> |
<tbody>
</tbody>