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))


"Brento" wrote:


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

thanks


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=573466