If you need to perform a row-by-row operation on a cell range and you want to keep the results in the corresponding rows (that is, if you operate on cells [10:20] and you want the results to be placed in cells 10-20 of the resulting column), compute specify the cell range [1:20] instead. This will compute some unnecessary values, but it will place the results in the wanted rows.