| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Req Formula to place 1 into next columns
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 |
|
#2
|
|||
|
|||
|
I think this may work for you
=IF(COLUMN(A1)<=$A1,1,"") Put in B1 and copy across to column J and down as many rows as needed "stge" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
| How do I drag a formula from right to left columns instead of rig. | Excel Discussion (Misc queries) | |||
Linear Mode
