Reference a row programmatically
 

If I have a column A, of data, as follows:

34
76
57
21
7
15

and I want B1 to reference A1, B2 to reference A5, B3 to reference A9 (I am incrementing by 4) how do I specify this in the formula for column B?

Thank You, RVic

Reference a row programmatically
 

The OFFSET() function solves this.

Reference a row programmatically
 

hi,

Am Wed, 24 Jul 2013 07:25:05 -0700 (PDT) schrieb RVic:

76
57
21
7
15

and I want B1 to reference A1, B2 to reference A5, B3 to reference A9 (I am incrementing by 4) how do I specify this in the formula for column B?

try in B1:
=INDEX($A$1:$A$100,(ROWS($1:1)-1)*4+1)
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2