Ask Your Question
0

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

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

this post is marked as community wiki

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

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]

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

lolax gravatar image

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

edit flag offensive delete link more
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 62 times

Last updated: Aug 22 '15