0
I have a formula in excel which contains an array; {1,2,3} its use can be seen at I would like to generate it dynamically eg arrayfun(4) would generate {1,2,3,4}. I can generate a very long array with COLUMN(1:1) but I need a formula which generates an array of explicit length.
The specific formula I'm trying to use this in is LINEST and an example of its use can be found at http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
So you want to take an existing array and append new elements to the end of it as a formula result? – Nate – 2015-02-23T21:16:03.163
No, I want to be able to dynamically generate the {1,2,3} as required in the formula to which I have linked. – Mr Purple – 2015-02-23T21:37:02.060