shortage

I have a formula which works, but I would like to see if it's as optimized as it could be. I've a new computer and it's either a LOT slower than my older one (very possible), or this forumla needs to be optimized with a better formula or moved to VBA. I am looking for the last instance of a...

Hi, I seem to be able to use index/match for a specific scenario but struggling to apply it to others so looking for some help - maybe that's not even the best way of doing it. I have two data sources a list of products and another data source with the products, order despatch dates and...

Hello, I have a workbook that we are using at work to track material allocations to work orders. What it does is show the customer order, the material it is short on, the job that exists that could satisfy the shortage, the quantity remaining of that job to fulfill the shortage, and the next...

Hiya all, I have a workbook in which my staff are responsible for maintaining. At the start of each week I have a snapshot of the week ahead. I have 3 columns which I am particularly interested in which shows Open Stock / Shortage Current Week / Shortage next week. They are responsible for...