Forum Discussion
Problem with formula
Hello i need help with my Excel. like i show elowe in printscreen i need to make delta of Stock and demanding quantity but how to make it for indexes that are dubbled to take stock - first demand and...
Hi AdrianMgdal
With data formatted as Table (not mandarory):
in D2 (can be shortened):
=LET(
i, COUNTIF(A$2:A2, [@Index]),
f, FILTER([Demand Qty], [Index]=[@Index]),
s, SUM(TAKE(f, i)),
[@[Stock Qty]] - s
)