Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I had earlier a array in a column with 200 rows, with a formula that pointed
at a range of 200 rows that's mostly empty, making a lot of ""\""\""\ - signs for the bottom part of the array column (after F9 is pressed when formula is selected). The array formula is still in the range of 200 rows, but now the formula just point at currently 37 rows dynamic named range, instead of the 200 that is the maximum possible. Some ""\""\""\ - signs are still there in the array column, but only a few. In the 200 rows array column, there will be a lot of "#Missing" errors, and the question is if the array work faster now .... In Short: 200 rows array = Formula -- 200 cells in one column 200 rows array = Formula -- Dynamic named range max. 200 cells in one column, but now 37 cells used Can anybody tell me from this description, if the arrays work faster by this? It make also me understand better how arrays work and become execute in excel.... (I bought FastExcel some days ago, and will be able to check this later, but it take a while to understand how to use it.) /Kind regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming |