Ask Your Question

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

asked 2015-08-21 10:46:08 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.


Using Libre Calc (Version:

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]

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-23 20:12:03.053472

2 Answers

Sort by » oldest newest most voted

answered 2015-08-22 00:33:31 +0100

erAck gravatar image

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 ...

edit flag offensive delete link more

answered 2015-08-22 05:32:29 +0100

lolax gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-08-21 10:46:08 +0100

Seen: 115 times

Last updated: Aug 22 '15