Jan 14 2021 08:16 AM
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
Jan 14 2021 09:03 AM
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).
Jan 14 2021 10:35 AM
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.