Reference a row programmatically

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top