When you fill a formula down or across the relative cell references always
adjust by one cell in each formula. The way I customize that when needed is
to use the OFFSET function instead of a direct cell reference. The ROWS and
COLS arguments of Offset can reference other cells where I have filled in my
unusual fill patterns like 1,1,2,2,3,3 etc. You might have to play with
this a bit to see what I'm talking about if you haven't used Offset before.
--
Jim
| is it possible to make a formula with a relative cell reference, or
| conditional absolute reference, that e.g. change the reference 1 step when
| copying cell 2 steps?
| ~roar