Forum Discussion
Receivable Aging Formula Challenge
Forty-five days after I posted my FIFO Inventory Formula Challenge and my solution thereto, here is another challenge to harden your array manipulation skills. As usual, we anticipate the valuable in...
May I second SergeiBaklan's vote of thanks for some innovative challenge problems.
The attached contains a version that is meant to work using standard Excel. It uses a strategy I employed before dynamic arrays came to Excel; that is, I used named formulas to hold the array formulas that I used all the time (this allowed me to avoid the effect of implicit intersection). Counting character length was not scientific; I tried to substitute the formula lengths to account for each occurrence of a name.