| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I'm cluesless - need help with "functions"?
In addition, make sure you have ToolsOptionsCalculation set to "Automatic"
Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 07:33:00 -0700, Max wrote: A46 says, =IF(B45="","",B45) Just drag the fill handle* of cell A46 down as far as required, to fill the formula in advance of expected data. The formula will auto-increment as desired, and the formula cells will appear "blank" until data is entered in col B. *that's the solid black square at the bottom right corner of the cell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
Threaded Mode
