I have been doing some formulas that use array constants for generating
harmonic series for wave tables
The array is very large and so far have been using ROW(1:1000) etc. to give me
the constant array.
My question is there any way to make a constant sequence that
contains only odd values i.e. 1,3,5,7,9,...infinity?
OK maybe not infinity but up to 9999.
I don't want to have to type them in manually.
Thanks