Hi Roger,

But nowhere could I find what ROW() signifies


ROW() returns the rownumber of the cell the function resides in, so
=ROW()

in Cell A63 returns 63.

Since I used the ROW() function as the column argument for the offset,
dragging the formula down forces an increase in the column argument of
the offset function. SO in fact when you move down one row, the formula
in that row points one column further to the right than the one
immediately above.

Clear as mud?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com