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,
Thanks PeterBartholomew1
I hope Lambda and Scan hit 365 soon 🤞
- If you are working with a corporate license you would need IT to sign you up for Insider beta for a while. I don't think the 2D grid I laid out is strictly necessary but it helped me work through the problem; FIFO calcs are not my forte!
- that's good to know. thank you
