Index Query not working

Ronderbecke

Board Regular
Joined
Oct 4, 2017
Messages
54
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.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,309
Let's say that you're going to enter the formula in B2 and copy it down the column. Try..

Code:
B2, copied down:

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

...which will reference the following...

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

Hope this helps!
 

Ronderbecke

Board Regular
Joined
Oct 4, 2017
Messages
54
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,521
Messages
5,529,325
Members
409,863
Latest member
stacy09
Top