Same result with different approach:

In A2 type: =IF(MOD(A1+1,4)=0,4,MOD(A1+1,4))

and drag copy down as far as necessary


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484630