Forum Discussion
How to Calculate LIFO with Dynamic Arrays
Hello All, I have a list of purchases and sales. In a new column, I would like to show the LIFO cost basis for each sales row. Using the "Let" function, I started down this path by loading (i) the...
Good luck with that as a task!
I probably have used functions that you do not have and would still require a lot of work to boil the calculation down to a single formula!
Note: SUMIFS can provide an alternative to SCAN when a running total is required.
This is amazing. I've been looking for this kind of solution for months. How can I use this for multiple products. Regads,