G
Gor_yee
Got a question..
Column A = Order
Column B = Thursday Stock on hand
Column C= Friday stock on hand
Column D = Saturday stock on hand
Column E = Sunday Stock on hand
Say in Column A, i've got about 2000 lines from an order that was
generated for a store on the tuesday. If the store took out 400 lines
out of that 2000 lines. Is there a formula or vlookup function that
can find out that the 400 lines has caused an out of stock on those
days??Please help.
Column A = Order
Column B = Thursday Stock on hand
Column C= Friday stock on hand
Column D = Saturday stock on hand
Column E = Sunday Stock on hand
Say in Column A, i've got about 2000 lines from an order that was
generated for a store on the tuesday. If the store took out 400 lines
out of that 2000 lines. Is there a formula or vlookup function that
can find out that the 400 lines has caused an out of stock on those
days??Please help.