SOLVED - Drag autofill whith increment in rows

2 replies [Last post]
pognonec
Offline
Last seen: 3 years 21 weeks ago
Title:
Joined: 18 Dec 2012
Posts: 2
Well, not very clear… :Cool Let’s say:

You have Column A with 100000 values (thus in 100000 consecutive rows).
You want to auto-fill Column B so that you have in B1 the value A1, in B2 the value A101, in B3 the value A201, and so on.

I manually filled the first ones (B1=A1, B2=A101, B3=A201)
What would be the solution? If there is a function for that, could it be tailored so as to easily change the value of the increment, through an “increment value” cell, for example?

Thanks!

Lupp
Lupp's picture
Offline
Last seen: 1 day 16 hours ago
Title: ★★★★★
Joined: 1 Aug 2012
Posts: 1515
Calculate an index or an adress
You can calculate the row of “Every Hundredth From The First On” as ( ( No – 1) * 100 +1) and use the result for concatenating the address (and use INDIRECT ( ) ) or as index ( and use INDEX ( ) ) into the array of your items in column A. See example!
AttachmentSize
4966EveryKthFromArray001.ods 47.54 KB

Currently installed: LibO V5.1.2 on Windows 10
Maybe we might! (Create a powerful UFO: United Free Office!) Lupp from München
pognonec
Offline
Last seen: 3 years 21 weeks ago
Title:
Joined: 18 Dec 2012
Posts: 2
Drag autofill whith increment in rows
Thanks Lupp, that will help me get what I was looking for.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.