Drag dwon formula increment cel value larger then 1

[Zand]

Hello,

I have a simple problem that I cannot get to work...

Problem
I have one list (vertical in one column) with data.
I want to create a second list (vertical one column) with a drag down formula that takes only every (for example) 3th value from the 1e list.

What did I do to solve it
I have searched the web many times found lots of basic drag down explanations (yes I know that 10-20... becomes 10-20-30-40 etc.) and found two solution that come up most.
That is OFFSET($A$3,(ROW()-1)*3,0) and I found solutions that use INDEX and COUNTA for 1e lists that are not fix but can grow longer.

I cannot get any to work. I must say I use a Dutch version but Translator solves that problem.
I do encounter this often, where I wish I could make a simple formule for this "problem".
In stead of labor intensive selecting cells piece by piece, I just want to drag down a formule, no selection errors and for long 1e lists, this is not nice to do.

Does anybody have a smart idea?
I like the fix with the OFFSET command.

Oh yes, in all the examples I found the 1e list is starting at A1... this does not have to be that way. My 1e list is starting at B5 (could be any other value but A1).

Thanks in advance!

Greetings, Pim

 

[Fluff]

How about

+Fluff v2.xlsm
	B	C
5	WEEK 1	WEEK 1
6	WEEK 2	WEEK 4
7	WEEK 3	WEEK 7
8	WEEK 4	WEEK 10
9	WEEK 5	WEEK 13
10	WEEK 6	WEEK 16
11	WEEK 7	WEEK 19
12	WEEK 8	WEEK 22
13	WEEK 9	WEEK 25
14	WEEK 10	WEEK 28
15	WEEK 11	WEEK 31
16	WEEK 12	WEEK 34
17	WEEK 13	WEEK 37
18	WEEK 14	WEEK 40
Week_List

Cell Formulas
Range	Formula
C5:C18	C5	=INDEX($B$5:$B$57,ROWS(D$5:D5)*3-2)

 

[Zand]

Hello Fluff,

You must think I am ungreatfull not to have answered sooner... I just was not getting to it earlier.

The XLBB Tool is great, copied formula and changed ROWS to the local RIJEN and figured out what it did.
What is column D doing?! Ah I got it, nothing, it just count the ROWS for the counter!

I did have to change the "," into a ";" as a divider for the Arguments in de Formula but then in works nicely.

I have to look into functions like INDEX and ROWS beter, simple and elegant solution. Much simpeler then stuff I saw online.

So many thanks!

Greetings, Pim
(Zandvoort NL)

 

[Fluff]

You're welcome & thanks for the feedback.
The D$5:D5 should really be C$5:C5 for safety sakes, it was a typo on my part.

 

[Zand]

I was just thinking of trying that out and indeed it works also in the same column.
Thanks

 

[Fluff]

My pleasure.