|
|
|
Инкремент адреса ячейки в формуле
|
|||
|---|---|---|---|
|
#18+
авторI have a formula =COUNTIF('Sheet1'!Ddd2346, "=0") in a cell, where Ddd2346 refers to a named range. What I would like to do is to have an easy way to copy this formula down a column of cells, and have the Ddd2346 number increment by one each time. The next cell needs to be Ddd2347, then Ddd2348 etc. In this specific case, use: =COUNTIF(INDIRECT("Ddd"&2345+ROW(A1)),"=0") When this formula is filled down the column, the numeric suffixes of the named ranges increment by one. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 18.07.2006, 12:09:39 |
|
||
|
|
start [/forum/topic.php?fid=61&msg=33860243&tid=2184607]: |
0ms |
get settings: |
8ms |
get forum list: |
14ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
42ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
44ms |
get tp. blocked users: |
1ms |
| others: | 254ms |
| total: | 380ms |
| 0 / 0 |
