Forum Discussion
Solved
How to autofill with non-adjacent cells
Hi all, I'm currently attempting to create a column with referenced cells that are separated by a row. For example, In column 😧 D1 would contain "=J4" , D2 would contain "=J6" , D3 would contain...
Cornellj730 Try either of following formulas-
=INDEX(J:J,SEQUENCE(10,1,4,2)) ="=J"&SEQUENCE(100,1,4,2)
Hi, Cornellj730
Try this way in Column 😧
=INDIRECT($B$1&ROW()*$B$3)
where the values in column B are variables
Regards,
Sergiusz