Exactly. I missed that "S".

On Fri, 29 Oct 2004 20:04:10 -0500, Dave Peterson wrote:

I'm betting you read it as: Row($1:1) and not RowS($1:1)?


Myrna Larson wrote:

Will that work when the formula is copied down? In the 2nd row, it becomes
an
array: $1:2

On Fri, 29 Oct 2004 18:03:21 -0500, Aladin Akyurek
wrote:


Myrna Larson Wrote:
But instead of ROW()-ROW($D$2)+1, which is dependent on the address of
the
cell with the formula, use Frank's formula where he just writes
ROW(1:!)

I don't know why, but I always forget about that!

[...]



ROW(1:1) and similar idioms should never be used for it is one of the
sources of spreadsheet errors by giving way to non-robust formulas.

If ROW()-ROW($D$2)+1 looks too baroque, you could use

ROWS($1:1)

instead (which I somewhat dislike because of how it looks when the
cursor is in the formula).