| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I do a variable length array based on the value in a cell
Think OFFSET could be used,
with the height param pointing to a cell. For eg, with the height param number in A1, say: 5 =OFFSET($B$1,,,A1) would return the range B1:B5 If A1 contains 10, then the range B1:B10 is returned And so on -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mark Pranger" <Mark wrote in message ... I want to create a cell range that will be based on the value of a cell so that i can change the value of the cell and the range will lengthened or shortened. Say I want to have the range start at cell b1 and go down the column for 10 cells. then I decide to change it to 15 cells and then 40 cells. But I don't want to have to rewrite the formula each time. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a cell value based on specific combinations of cells in an array | Excel Worksheet Functions | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
Hybrid Mode
