Forum Discussion
Loss carry forward for limited years
Hello Excel Community, Excel Version: O365 (Enterprise) I’m running into a mental block trying to model loss carryforward with limited years using a spill formula. Below is a simplified example...
I have the functions to make for an elegant FIFOλ/LIFOλ lambda though I hesitate to finalize it because the arrangement of FIFO data is not always the same.
Is there a "typical" arrangement that can be banked on?
"Typical arrangement" ... I doubt it!
I have attached a file that contains a possible layout for a single product line.
The file was used to support an on-line presentation so it is more focussed upon demonstrating solution techniques than attempting the most efficient solution for each problem. The message being that a dynamic array solution in Excel may have very little in common with the traditional spreadsheet!