Index Query not working

[Ronderbecke]

I have a formula to query every 12th line using the index function. For some reason it is pulling every single line rather than every 12th line? I cannot seem to make the every 12th line work on it? Why does it pull every individual line?

=Query(INDEX('Jason Smith'!$C$1:$C,(ROWS('Jason Smith'!C1)-1)*12,0))

Thank you so much for the help.

 

[Domenic]

Let's say that you're going to enter the formula in B2 and copy it down the column. Try..

B2, copied down:

=Query(INDEX('Jason Smith'!$C:$C,ROWS($B$2:$B2)*12-12+1))

...which will reference the following...

'Jason Smith'!C1
'Jason Smith'!C13
'Jason Smith'!C25
'etc
'
'

Hope this helps!

 

[Ronderbecke]

Hey Domenic,

I apologize if this posts twice but for some reason it didn't update on my computer for the post. I was hoping to use query to make it "auto populate" the cells and continue to do so as more were input (essentially pull C1:C10000 but only pull every 12th cell and continue to pull as they populate). Is that possible? I have tried multiple functions and I seem to do great with Query except I cannot make it only pull every nth cell?