# Auto increments with offset

#### Tian1

##### Board Regular
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!

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
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
MT
129
222
318
421
519
622
727
3322
34
35
36
37
38
39
40
41
42
43
44
4518
46
47
48
49
50
51
52
53
54
55
56
5721
Sheet1
Cell Formulas
RangeFormula
T33=IF(MOD(ROW()-21,12)<>0,"",OFFSET(\$M\$1,(ROW()-21)/12,0))

Hi!

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

Replies
5
Views
531
Replies
4
Views
425
Replies
3
Views
317
Replies
3
Views
456
Replies
3
Views
638

1,203,608
Messages
6,056,286
Members
444,855
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back