Auto increments with offset

[Tian1]

Hallo,

I am trying to solve what X should be in the following formula. In T33 I have =OFFSET(RUsed!$M$2,X,0).

The formula will be dragged down by skipping 11 cells and on the 12th cell (T45) the formula will appear again. The first X (T33) should be 1 and the second (T45) should be 2. I am just trying to figure out a way to do this automatically (perhaps with the ROW() formula)?

Any ideas?

Thanks!

 

[Momentman]

Like this maybe, I had to get a formula which correlates 1 to 33, 2 to 45, and 3 to 57 e.t.c which is 33=12*1+21, 45=12*2+21, 57 = 12*3+21, see if the output matches your request, in order cells asides the once mentioned, the value is blank("")

Excel 2010
	M	T
1	29
2	22
3	18
4	21
5	19
6	22
7	27
33		22
34
35
36
37
38
39
40
41
42
43
44
45		18
46
47
48
49
50
51
52
53
54
55
56
57		21
Sheet1

Cell Formulas
Range	Formula
T33	=IF(MOD(ROW()-21,12)<>0,"",OFFSET($M$1,(ROW()-21)/12,0))

 

[Tian1]

Hi!

Jip, that works as it should. Thanks for the help, I appreciate it.