Copy cell from every nth row

I would like to get the names in each name from this google spreadsheet and put it in a new column. The names will represent every nth line.

get every nth row in google spreadsheet


source to share

2 answers

Alternatively try also:

=filter(A2:A, mod(row(A2:A)+1,3)=0)




In B2 try:



As the formula is copied down, offset from A1 is increased by three, without offsetting the column. In the second (starting line) 3 * (2-1) -2 is 1, so A2 is returned. On the second output line, 3 * (3-1) -2 returns 4, so A5 is returned, etc.



All Articles