Forum Discussion
Excel large, n=2 and n=3 return the same value.
I confess, there have been times when I wonder whether I am helping or causing more confusion when I post a solution that I know will appear totally alien to almost all Excel users. In addition, I do not think I have reached a balanced view concerning the limits of how deep a LET formula should be taken.
I think I had a similar dilemma when I first realised that Named formulas could be nested one within the other several deep. It was both liberating (array formulas without the CSE) but, at the same time, it didn't seem entirely right to strike out on such a lone path (even if it did enable me to translate numerical currency values into natural language (I tried English and German). It worked fine, but it was even questionable whether MS had any obligation to support such use.
I did get around to publishing some initial thoughts on dynamic arrays and presented the paper last year. Since then, Charles Williams, whom I assume you know, included ACCUMULATE in FastExcel.
Hogstad_Raadgivning If this exchange has moved too far from your initial question, do not hesitate to bring the discussion back on topic.
PeterBartholomew1 , that's a great paper. Can't say I fully agree with everything, but hope I catch your point.