Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to extract every n-th row using array formula

I try to extract every nth row of my datatable. I know how to do it using INDIRECT and ROW formulas, I could try search the content and extract data this way (arrayformula + if(regexmatch())

But I wonder if there's a way to make it in one line. With no respect for it's content.

I tried INDEX, OFFSET, INDIRECT but these functions does not work with ARRAYFORMULA in the way I expected.

enter image description here

You can play with my data here: https://docs.google.com/spreadsheets/d/1KUqXTvRlONbi5f3w3bVwVPBKfxWiSfiXsO5vHPWDiog/edit?usp=sharing

like image 662
Krzysztof Dołęgowski Avatar asked Mar 14 '26 09:03

Krzysztof Dołęgowski


1 Answers

use:

=FILTER(A5:A; MOD(ROW(A5:A)+1; 3)=0)

enter image description here

like image 192
player0 Avatar answered Mar 16 '26 01:03

player0