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...
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