Reference a row programmatically

  • Thread starter Thread starter RVic
  • Start date Start date
R

RVic

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
 
Back
Top