Dec 29 2020 09:00 PM
Item | SO ID | SO Qty | Stock | Difference |
A | A123 | 10 | 12 | 0 |
B | A124 | 5 | 5 | 0 |
A | A125 | 7 | 12 | -5 |
I'm unable to perform operation in excel for stock inventory.
As above table, Item A has two sale orders and Stock column was done VLookup. Hence same qty shown for Item A. I like to find difference where Item A SO ID A123 will be allocated 10 Qty. The Remaining 2 Qty will be allocated to Order ID A125.
Kindly help us solution for it.
Dec 30 2020 06:55 AM
@vangashiva I think we need more information about what you want because there are many solutions but I think most will not give you what you really want. For example you could just use =D2-C2 but I assume that is too specific for this 1 case. I believe you say you have a VLOOKUP formula in the Stock cell, so maybe tweak that formula to something like
=VLOOKUP(what you have now) - SUMIF($A$1:$A1,A2,$C$1:$C1)
so it will still do the stock lookup based on ITEM but then subtract all previous SO QTY found in the table.
Dec 31 2020 12:58 AM
I cannot subtract directly as multiple times it will repeat the value. I like to display row wise difference which is not happening. In real practical scenario, there will be multiple columns available apart from above table.
Please suggest some solution.
Dec 31 2020 04:17 AM
@vangashiva Sorry I don't know what you are looking for. We need more information. Maybe attach a sample sheet. What you have said just isn't enough for me to understand.