If I have the number 4 in column 'A' row 1, what formula do I need to
place a '1' into the next four columns (representing each of the 4 days
in column 'A'). I need to have a formula that would work from 0-9

Any help would be useful
Regards
stge


--
stge
------------------------------------------------------------------------
stge's Profile: http://www.excelforum.com/member.php...o&userid=16068
View this thread: http://www.excelforum.com/showthread...hreadid=276214