copy formula

[j4ymf]

Good morning, but of a strange one and i don't really know how to ask the question.
If i have a range that i want to copy and duplicate how would i be able to follow the data.

IF A5 is = E1 and i copy it down 9 rows the the next formula wull look at E13 but i would like it to =E2 is that possible?

 

[hagia_sofia]

Hello, could you please elaborate on how the output should look like - e.g. should the sequence go like

=TOCOL(IF(SEQUENCE(,3),SEQUENCE(8))+SEQUENCE(,3,0),,TRUE)

or something else?

 

[j4ymf]

Hi hagia_sofia
thanks for the reply

the sequence im looking for would be

A1 is =E1 value 1
A13 = E2 value 2
A21 = E3 value 3
A29 = E4 value 4

 

[hagia_sofia]

Many thanks for the reply. But i am still confused - could you please look at the attachment and tell me which one is correct (if any)?

=TOCOL(EXPAND(SEQUENCE(13),,8,""))

=TOCOL(IF(SEQUENCE(,3),SEQUENCE(8))+SEQUENCE(,3,0),,TRUE)

 

[hrayani]

Hi @j4ymf

is this what you want ??

Book3
	A	B	C	D	E
1	1				1
2					2
3					3
4
5
6
7
8
9	2
10
11
12
13
14
15
16
17	3
Sheet1

Cell Formulas
Range	Formula
A1,A17,A9	A1	=INDEX(E:E, (ROW(A1)-1)/8 + 1)

 

[Scott Huish]

Is the incremental nature of your sample in Column E truly representative of your data?

Or could it be something like this? (Expanding on hagia_sofia's answer)

Book2
	A	B	C	D	E
1	1				1
2					14
3					3
4					16
5
6
7
8
9	14
10
11
12
13
14
15
16
17	3
18
19
20
21
22
23
24
25	16
Sheet1

Cell Formulas
Range	Formula
A1:A95	A1	=TOCOL(EXPAND(E1:E13,,8,""),TRUE)
Dynamic array formulas.