View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RVic RVic is offline
external usenet poster
 
Posts: 3
Default 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