How to make a list with values from A1, A13, A25, this is, from every "+12" cell?

[ajrsantos]

Hello,

Using Libre Calc (Version: 4.4.5.2).

I’d like to build a list (column) containing values from A1, A13, A25, this is every 12 cell bellow. Would anyone advise about any function to this?

Thanks,
AS

[Edit: added lo4 tag]

[erAck]

Add a second column with values from 1…12, repeating (enter one series once (or use Fill Series), then copy to clipboard and paste over all rows you want to cover), then use AutoFilter to display only rows with 1, or 2, or …

[lolax]

how about the formula =INDIRECT(“A”&(ROW(A1)-1)*12+1)