A drag forumula which jumps 3 column in google sheets-CodePudding

in Google Sheets, I need a drag formula in which row stays same but column number jumps 3 columns each time. For example:

=‘TEMMUZ 2022’!O3 then =‘TEMMUZ 2022’!O6 then =‘TEMMUZ 2022’!O9.

I couldn’t find a way. Most probably with an array formula but I am not good with them. Anyone has an idea? Thanks.

CodePudding user response：

use instead of dragging:

=FILTER(O3:O; MOD(ROW(O3:O); 3)=0)

CodePudding user response：

In your situation, use a unique formula for all the 3 columns

=ARRAYFORMULA(TRANSPOSE(VLOOKUP(TRANSPOSE(SEQUENCE(ROUNDUP(COUNTA( 'TEMMUZ 2022'!O3:O)/3);3;ROW('TEMMUZ 2022'!A3)));{ROW('TEMMUZ 2022'!A3:A)\'TEMMUZ 2022'!O3:O};2;0)))