Forum Discussion
Twifoo
Feb 08, 2021Silver Contributor
FIFO Inventory Formula Challenge
To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills. Perhaps, keenadvice mathetes Riny_van_Eekelen PeterBa...
PeterBartholomew1
Feb 09, 2021Silver Contributor
Robert, I was going to apologise for using your challenges to explore the developing product that is Excel and learning new techniques rather than addressing the terms of the challenge head on. It appears that I may not be alone in this!
I did even consider using recursion to keep a running total of stock value transaction by transaction but came to the conclusion that it would be too heavy in terms of its computation and would represent overkill. I also wondered whether there is opportunity for a greater level of nested Lambda functions to expose the overarching logic to a greater extent but getting my brain to shift gears is not coming easily! I had a look at some theory but the function representing recursion
λ(λx.x x) (λx.x x)
does not come easily to me.
- SimoneBraccioDec 16, 2024Copper Contributor
Thank you Mr. Bartholomew, that was very interesting.
How would you approach the same problem in the case one wanted to determine the time spend in the inventory by each item (imagining that to each sale or purchase transaction a corresponding date was attached).
I have been trying to do that in a dynamic way but have not succeeded so far unfortunately.
Thank you,
Simone