Forum Discussion

Copper Contributor

Jan 28, 2024

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...

excel

Formulas and Functions

Harun24HR
Jan 29, 2024
Cornellj730 Try either of following formulas-
=INDEX(J:J,SEQUENCE(10,1,4,2)) ="=J"&SEQUENCE(100,1,4,2)
reference.xlsx11 KB

Harun24HR

Bronze Contributor

Jan 29, 2024

Cornellj730 Try either of following formulas-

=INDEX(J:J,SEQUENCE(10,1,4,2))
="=J"&SEQUENCE(100,1,4,2)

reference.xlsx11 KB

Cornellj730
Copper Contributor
Jan 30, 2024
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!
- Harun24HR
  Bronze Contributor
  Jan 30, 2024
  Glad to know! If it helps then please mark this answer as best response to treat the question as solved.