I need to copy a formula in excel but only every 3rd row. Please see the image as reference:
And I need this for about 5000 cells so I ideally would be to drag it down but when I do that excel just references the same row instead the next one from Column A
There is an example on how to do this and skip one cell, but in my case I want to skip 2 cells. The example is:
=IF(C1="",INDEX($A$2:$A$20,COUNTBLANK($C$1:C1)),"")
and is posted HERE
From cell C1 and drag down:
=IF(INT((ROW()+2)/3)=(ROW()+2)/3,INDIRECT("A"&((ROW()+2)/3)),"")
Or:
=IFERROR(INDIRECT("A"&(ROW()+2)/3),"")
Or non-volatile:
=IF(INT((ROW()+2)/3)=(ROW()+2)/3,INDEX($A$1:$A$10,(ROW()+2)/3),"")
Or another non-volatile:
=IF(MOD((ROW()+2)/3,1)=0,INDEX($A$1:$A$10,(ROW()+2)/3),"")
From cell C2 and drag down:
=IF(INT((ROW()+1)/3)=(ROW()+1)/3,INDIRECT("A"&((ROW()+1)/3)+1),"")
Or:
=IFERROR(INDIRECT("A"&((ROW()+1)/3)+1),"")
Or non-volatile:
=IF(INT((ROW()+1)/3)=(ROW()+1)/3,INDEX($A$1:$A$10,(ROW()+1)/3),"")
Or another non-volatile:
=IF(MOD((ROW()+1)/3,1)=0,INDEX($A$1:$A$10,(ROW()+1)/3),"")
