Search results

Hi, For below example table: - order product quantity date 1 a 3 01/01/1111 2 a 2 02/01/1111 3 b 1 01/01/1111 say you had 4 units of product "a" in stock. how could you minus the stock sequentially from each record until it had been used up? so for example you minus 4 from the...

Hi, new to forum, access n00b. Maybe in the wrong place, this may be achievable in excel. I have raw data that is exported from a program in this format. product raw material amount Product 1 raw material 1 54 Product 1 raw material 2 41 Product 1 raw material 3 1 Product 1 raw material 4 45...