Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More info !
Hi All,
what is dynamic array ? how is this used ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More info !
"fi.or.jp.de" wrote...
what is dynamic array ? how is this used ? A contrived example. Name a cell N, and enter 24 into it. Define another name S as the formula =ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,N,1)) Use it in a formula like =SUMPRODUCT(INDEX(C3:C1000,999-N):C1000,S) This returns a weighted sum of the last N (24 per the example) values in C3:C1000. Dynamic ranges are more commonly used than dynamic arrays, but the intent of both is to allow the model to change the size and sometimes the shape of ranges or arrays used in formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |