Ask Your Question

How to subtract

asked 2019-03-26 21:09:37 +0100

Ahmad Mansour gravatar image

updated 2019-03-27 21:02:12 +0100

I have two sheets for warehouse inventory, in first one subtotals of materials with total quantity and the second the same materials with batchs ie in first sheet the material in one row and in the second in many columns If i have deficit or increase i want it automatically take the difference from the first batch and if run out take from the next etc C:\fakepath\warehouse inv.xlsx

edit retag flag offensive close merge delete


The exact operations that you are trying to perform are obviously difficult to describe in words alone. It would be a good idea if you gave us an example, a sample spreadsheet (not a screen capture) showing the values in cells and the calculations that you want to have done.

ve3oat gravatar imageve3oat ( 2019-03-26 23:17:09 +0100 )edit

Uploaded I need in real stock in sheet2 take the difference from sheet1 and put the values of each batch after calculating the difference by FEFO

Ahmad Mansour gravatar imageAhmad Mansour ( 2019-03-27 21:04:46 +0100 )edit

Just to be clear, can you fill the expected results for the "real stock" in sheet 2, and upload again. Thanks.

gregors15 gravatar imagegregors15 ( 2019-03-30 13:56:54 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-03 13:12:59 +0100

gregors15 gravatar image

Hi Have a look at the attached sheet, see if it helps, You will need to create a pivot table each time you need to use it exactly as mine and then copy the columns (GtoN) to do the calculations. I change 2 columns in your sheet which I coloured blue again you will need to re-create both each time used. Regards. C:\fakepath\HowToSubtract_20190403.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-26 21:09:37 +0100

Seen: 1,176 times

Last updated: Apr 03 '19