Forum Discussion
FIFO Inventory Formula Challenge
Oh, my! It's an honor to be included among such august company, an honor I fear I don't deserve at all. I'm here to learn, and occasionally offer some more basic suggestions.
But, challenged, I'll give it a try later today.
mathetes An honor, yes; but undeserving, no! With your acceptance, I anticipate your valuable insights that will certainly augment our common quest for knowledge.
Well, guys, if this were a chess match (which, metaphorically, it is) I would tip my king on its side, and reach out to shake your hands.
I've truly had fun learning how to nest FILTER within INDEX and COUNT (among others), have formulas that will get each of the salient numbers here, and could write a LET to define all the re-used array formulations, but my head is starting to feel as it it might explode just from contemplating putting them all into a single formula, as Robert has stipulated, to say nothing of actually doing it.
So it's been a learning experience for sure, and I look forward to applying my learnings. I'll keep looking over your shoulders in months ahead. I AM going to spend some time studying each of your solutions.
- If you imagine that Chess Moves could be translated to Excel Formulas, I earlier posted my version of my imagination here:
https://techcommunity.microsoft.com/t5/excel/excel-chessgames-viewer/m-p/765672
