|
|
#2
03-14-2017, 10:27 PM
|
|||
|
|||
Enter in E1 and copy down:
=IF(ROWS($1:1)<=$C$4,ROWS($1:1),IF(ROWS($1:1)<=$C$ 4+$C$5,ROW()-$C$4,IF(ROWS($1:1)<=$C$4+$C$5+$C$6,ROW()-$C$4-$C$5""))) If you start in another cell than E1, for example H8 the formula should look like this: IF(ROWS($1:1)<=$C$4,ROWS($1:1),IF(ROWS($1:1)<=$C$4 +$C$5,ROW()-CELL("row",$H$8)+1-$C$4,IF(ROWS($1:1)<=$C$4+$C$5+$C$6,ROW()-CELL("row",$H$8)+1-$C$4-$C$5;""))) The two CELL functions must have the start cell as second argument. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| filling in blank cells with data from cell above | RayK | Excel | 1 | 01-12-2017 04:14 PM |
 matching data from one work sheet to another, then auto filling missing cell information
|
timomaha | Excel | 1 | 09-12-2014 07:51 AM |
|
Text Form Fields - Filling the table cell
|
simville02 | Word Tables | 1 | 01-31-2013 11:12 PM |
|
Image filling a Word table cell completely?
|
Elisabeth | Word Tables | 1 | 07-18-2012 07:21 AM |
| Filling the consecutive cell by day. | aligahk06 | Excel | 1 | 09-15-2010 08:17 AM |
Windows 10 
Office 2016
Threaded Mode