In article ,
Aladin Akyurek wrote:
ROW() always returns an array, not a scalar. Hence the choice.
Even with the following reference?
ROW(T412)
Doesn't that return a single number, that being 412?
I devised this formula many moons ago to capture multiple situations in
which the 'every Nth' questions arise (see SUMEVERY.XLS, I believe, by
Pearson). One set is whether one wants the formula to operate starting
with the topmost cell or the first Nth cell.
+0 means: start with the topmost cell (not coercion) and +1 start with
the first Nth.
I definitely like it. I'll be adopting it, as I usually try to do with
any of your formulas. :)
|