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)
HansVogelaarThank you so much for the help! This formula works well, but I quickly figured out that I needed something that I could manipulate a little easier (like the suggestion in the comment below). I appreciate the introduction to INDEX however. 🙂
