how to auto-fill a row with data from every other cell in a column?

[kyouryo]

Hello,

I wanted to know if there is a formula I can use to auto-fill row 3 (b - z) with information from column G starting at 85 and only with the information that appears every 2 cells down; I need data from G85 in F3, G88 in G3 and so on.

If my explanation is not clear, I'll try to be more descriptive if needed; English is not my first language and I'm not familiar with Excel terms. Thank you so much for your help.

 

[myall_blues]

Do you need to check that the dates match?

If not, then put this formula in F3 and copy it to the right.

=OFFSET($G$85,(COLUMN(G85)-7)*3,0)

Book1
	D	E	F	G	H	I	J
1
2
3			1.29	3.02	3.62
4
84
85				1.29
86
87
88				3.02
89
90
91				3.62
92
Sheet1

Cell Formulas
Range	Formula
F3:H3	F3	=OFFSET($G$85,(COLUMN(G85)-7)*3,0)

 

[kyouryo]

Oh thank you! That's exactly what I need. Sadly, I've tried using the formula and it seems that it isn't available in the version of Excel I have (2019); it kept giving me a value! error and typing it myself didn't make it pop up in the drop-down menu

 

[myall_blues]

Are you sure? OFFSET has been available since Excel 2016 for Windows and 2019 for Mac.

 

[kyouryo]

Are you sure? OFFSET has been available since Excel 2016 for Windows and 2019 for Mac.

You're right! It finally worked. It turned out to be a mistake on my end (forgot sometimes formulas change names between languages; so of course my Excel didn't recognise "offset"). After finding the translated formula, I struggled a bit to get it to repeat itself to the right as it kept referencing the same cell and not going two cells down. I recreated your example on a new sheet and it worked just fine, so I gave it another try on the actual sheet I need it in and finally got it! Thank you so much.

 

[myall_blues]

Great news. Glad you got it working.