do query and offset work together?

Ronderbecke

Board Regular
Joined
Oct 4, 2017
Messages
54
Currently I have an offset function that I use to grab every 12th cell (starting at the first one and I can drag down as many rows as necessary). Here is the offset function:

=OFFSET
('Travis Jones'!$C$1,(ROW('Travis Jones'!C1)-1)*12,0)

Is there a way to use the query function to go down the list of the whole sheet instead? I tried:

=query(OFFSET('Travis Jones'!$C$1:C,(ROW('Travis Jones'!C1)-1)*12,0))

but it gave me every cell and not just every 12th cell. I feel like I should be using the mod function with Query, but I am honestly lost at how to make Query work and only grab every Nth cell?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,108,991
Messages
5,526,105
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top