Hi,
I'm looking for an excel formula that can create a one-dimensional array from a single cell, repeating the cells value n times. e.g. cell A1 has value 200, the result of the formula should be an array that looks like this: {200,200,200,200,200,200,200}
The challenge lies in the fact that I...