John Davis
New member
Good afternoon all,
I have an equation that takes a row of 18 cells and puts it into a column of 18 cells. No problem there. But what I need to know is how to use the equation for the next set of 18 cells right below the first. This is my equation =INDEX($B$1:$S$1,ROWS(A$1:A1)). I put this in A1 and auto fill drag down to row 18.
How do i repeat this step for my next 18 rows (that have different information that the top row)? A small example below. So after I auto fill here from A1 to A3, how can I alter the original equation to keep going and make r s and t appear in A4:6? Is there a way to +18 to all the numerals in the formula so it will keep adding 18 (in the example +3) for every next set? But still be able to auto fill (A2, A3 in the example)?
A B C D
1 x x y z
2 y
3 z
4 ? r s t
5 ?
6 ?
Thanks!
PS I attached the top portion of the file in question to this thread.
I have an equation that takes a row of 18 cells and puts it into a column of 18 cells. No problem there. But what I need to know is how to use the equation for the next set of 18 cells right below the first. This is my equation =INDEX($B$1:$S$1,ROWS(A$1:A1)). I put this in A1 and auto fill drag down to row 18.
How do i repeat this step for my next 18 rows (that have different information that the top row)? A small example below. So after I auto fill here from A1 to A3, how can I alter the original equation to keep going and make r s and t appear in A4:6? Is there a way to +18 to all the numerals in the formula so it will keep adding 18 (in the example +3) for every next set? But still be able to auto fill (A2, A3 in the example)?
A B C D
1 x x y z
2 y
3 z
4 ? r s t
5 ?
6 ?
Thanks!
PS I attached the top portion of the file in question to this thread.