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.

You can play with my data here: https://docs.google.com/spreadsheets/d/1KUqXTvRlONbi5f3w3bVwVPBKfxWiSfiXsO5vHPWDiog/edit?usp=sharing
use:
=FILTER(A5:A; MOD(ROW(A5:A)+1; 3)=0)

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With