Formulas

Copper Contributor

How do I keep the same column (ex. 'F') but change the row to the following row?

Ex:  I have a column named Oct and am using different rows to calculate a number.  

=F3

=F17

=F31

I want to do the next column (Nov) as

=F4

=F18

=F32

The following column (Dec) as

=F5

=F19

=F32 

2 Replies

@Holly622 

Let's say the first formula will be in cell K2. Change the formula to

 

=INDEX($F:$F,14*(ROW()-ROW($K$2))+COLUMN()-COLUMN($K$2)+3)

 

If the formula will be in another cell, change it correspondingly.

You can copy/drag this formula to the right and down (or vice versa).

@Hans Vogelaar 

 

Thank you.  I am a novice at Excel and really don't understand this, but thank you so much for trying to help me!  It's not that large a spreadsheet so I will manually enter my formula.  Seriously thank you.