Plus a cell reference

B

Brento

Hi,

Im trying to add a formula that adds +1 to a cell reference number.

example
a
1=c12 original
2=c12
3=c12
4=c12
5=a1+1 cell ref which would be c13
6=a2+1 cell ref which would be c13

I have tried drag and drop and it does not follow sequence

thank
 
J

JLatham

Put this in cell A1 and then fill down with it.

=IF(ROW(A1)>4,OFFSET(C$12,INT(ROW(A1)/4),0),OFFSET(C$12,0,0))
 
J

JLatham

Disregard what I just posted - after putting it up, I noticed that there is
one group that is just a set of 3 instead of a set of 4, others are OK.
Working on correcting that.
 
J

JLatham

OK, after a couple of false starts, this will give you groups of 4. Put this
formula in A1 and extend it down:

=OFFSET(C$12,INT((ROW(A1)-1)/4),0)
 
Top