| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilling incremental numbers in a formula
I need to figure out how to auto fill a formula: =IF('Actual
Sched'!CS22=0,'Actual Sched'!CS21,'Actual Sched'!CS22) to become =IF('Actual Sched'!CS26=0,'Actual Sched'!CS25,'Actual Sched'!CS26) and more increasing the cell number by four for each line. Any wisdom to share? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofilling incremental numbers in a formula
One way ..
Replace: =IF('Actual Sched'!CS22=0,'Actual Sched'!CS21,'Actual Sched'!CS22) with: =IF(INDIRECT("'Actual Sched'!CS"&ROW(A1)*4+18)=0,INDIRECT("'Actual Sched'!CS"&ROW(A1)*4+17),INDIRECT("'Actual Sched'!CS"&ROW(A1)*4+18)) Then copy the cell down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Math Geek" wrote: I need to figure out how to auto fill a formula: =IF('Actual Sched'!CS22=0,'Actual Sched'!CS21,'Actual Sched'!CS22) to become =IF('Actual Sched'!CS26=0,'Actual Sched'!CS25,'Actual Sched'!CS26) and more increasing the cell number by four for each line. Any wisdom to share? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofilling incremental numbers in a formula
Here's the non-volatile version:
=IF(INDEX('Actual Sched'!CS:CS,ROWS($1:1)*4+18)=0,INDEX('Actual Sched'!CS:CS,ROWS($1:1)*4+17),INDEX('Actual Sched'!CS:CS,ROWS($1:1)*4+18)) Biff "Max" wrote in message ... One way .. Replace: =IF('Actual Sched'!CS22=0,'Actual Sched'!CS21,'Actual Sched'!CS22) with: =IF(INDIRECT("'Actual Sched'!CS"&ROW(A1)*4+18)=0,INDIRECT("'Actual Sched'!CS"&ROW(A1)*4+17),INDIRECT("'Actual Sched'!CS"&ROW(A1)*4+18)) Then copy the cell down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Math Geek" wrote: I need to figure out how to auto fill a formula: =IF('Actual Sched'!CS22=0,'Actual Sched'!CS21,'Actual Sched'!CS22) to become =IF('Actual Sched'!CS26=0,'Actual Sched'!CS25,'Actual Sched'!CS26) and more increasing the cell number by four for each line. Any wisdom to share? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| Suggestions on formula to track powerball numbers? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
