| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect address
Hi all
In Row 490 Column H I have the following =INDIRECT("'Road Cash Accounting'!"&ADDRESS(INT(ROW()/49),(INT(COLUMN()+1)))),0) This displays the value in 'Road Cash Accounting'$I$10 How can I adapt the above formula in cell Row 539 Column H ( 49 rows on. This repeats every 49 rows) to pick out 'Road Cash Accounting'$I$52 ( 42 lines on. This repeats every 42 lines) Hope someone can help Best Stew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDIRECT and ADDRESS | Excel Worksheet Functions | |||
| indirect with address list | Excel Worksheet Functions | |||
| using INDIRECT(ADDRESS(...)) | Excel Discussion (Misc queries) | |||
| Indirect(Address(... | Excel Discussion (Misc queries) | |||
Threaded Mode
