Offset Function

[c0087]

How would I edit this function so that I could get every 3rd row, then 5th row, 3rd row, 5th row, etc...

=OFFSET($A$1,(ROW()-1)*3,0)

 

[Snakehips]

Does this help?

Book1
	A	B	C
1	Data	Result	Or
2	1	1	1
3	2	4	4
4	3	9	9
5	4	12	12
6	5	17	17
7	6	20	20
8	7	25	25
9	8	28	28
10	9	33	33
11	10	36	36
12	11	41	41
13	12	44	44
14	13	49	49
15	14
16	15
17	16
18	17
19	18
20	19
21	20
22	21
23	22
24	23
25	24
26	25
27	26
28	27
29	28
30	29
31	30
32	31
33	32
34	33
35	34
36	35
37	36
38	37
39	38
40	39
41	40
42	41
43	42
44	43
45	44
46	45
47	46
48	47
49	48
50	49
51	50
Sheet2

Cell Formulas
Range	Formula
B2:B14	B2	=OFFSET($A$2,(ROWS(A$1:A1)/2*8)-5+ISODD(ROWS(A$1:A1)),0)
C2:C14	C2	=LET(rs,ROWS(A$1:A1),OFFSET($A$2,(rs/2*8)-5+ISODD(rs),0))

 

[c0087]

Here's the best I can come up with so far that does not use a helper column and let you drag. Only draw back is you have to reference the first value A1 yourself so it knows where to start.

Book1.xlsx
	A	B
1	1	1
2	2	4
3	3	9
4	4	12
5	5	17
6	6	20
7	7	25
8	8	28
9	9	33
10	10	36
11	11	41
12	12	44
13	13	49
14	14
15	15
16	16
17	17
18	18
19	19
20	20
21	21
22	22
23	23
24	24
25	25
26	26
27	27
28	28
29	29
30	30
31	31
32	32
33	33
34	34
35	35
36	36
37	37
38	38
39	39
40	40
41	41
42	42
43	43
44	44
45	45
46	46
47	47
48	48
49	49
50	50
Sheet1

Cell Formulas
Range	Formula
B1	B1	=A1
B2:B13	B2	=LET(a,INDIRECT(CELL("address",INDIRECT("A"&MATCH(B1,$A$1:$A$50,0)))),OFFSET(a,IF(MOD(ROW(),2),5,3),0))

It works because none of the numbers repeat in the example, but when i have my data, or random numbers that repeat, it loops back to the first match of the repeating number and repeats from there. If you could find a way around that issue it would be perfect, because then I could always change the 5,3 to fit whatever sequence I need in the future.