Reputation: 3

Output cell every nth row

How can I output a cell's value every nth rows

Example every 3 rows:

Upvotes: 0

Answers (4)

Reputation: 68

Offset is relatively simple. To get an index that increases by 1 every three rows just ROUNDDOWN the ROW address by three

=OFFSET($C$2,ROUNDDOWN(ROW(A1),0)/3,0)

Upvotes: 0

Reputation: 5852

Put this formula in A2:

=ArrayFormula(FLATTEN(SPLIT(REPT(C2:C4&"♦︎",3),"♦︎")))

Upvotes: 0

Reputation: 1

or you can do it with QUERY:

=QUERY(A2:A, "skipping 3")

Upvotes: 3

Reputation: 1

use MOD:

=FILTER(A2:A, MOD(ROW(A2:A)-2, 3)=0)

Upvotes: 1