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 "=J8" , and so on. Autofill doesn't recognize this pattern when I try to use it; is there any way to get around this/get it to recognize the pattern?
Cornellj730 Try either of following formulas-
=INDEX(J:J,SEQUENCE(10,1,4,2)) ="=J"&SEQUENCE(100,1,4,2)
With 365 you can use array shaping formulas as an alternative to INDEX.
= CHOOSECOLS(WRAPROWS(testData, step), step)will return the final column of each record.
Hi, Cornellj730
Try this way in Column 😧
=INDIRECT($B$1&ROW()*$B$3)
where the values in column B are variablesRegards,
SergiuszCornellj730 Try either of following formulas-
=INDEX(J:J,SEQUENCE(10,1,4,2)) ="=J"&SEQUENCE(100,1,4,2)- Harun24HR I ended up using this formula because the sequence formula allows me to be a little more flexible in the values I need to call. Thank you for the help!
- Glad to know! If it helps then please mark this answer as best response to treat the question as solved.
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. 🙂
