cheers for the reply guys.

daddylonglegs, could you explain how your equation works, im not very
familiar with the MOD function.

ill mess about with both and see how i get on


--
colonel-shoe
------------------------------------------------------------------------
colonel-shoe's Profile: http://www.excelforum.com/member.php...o&userid=34695
View this thread: http://www.excelforum.com/showthread...hreadid=544631