Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MY ARRAY FORMULA IS SLOW IF DATA LIST IS MORE THAN 10000R0WS
My array formula works very slower if the data list is more than 10000 rows
and 200 columns. This situation i could not avoid also. Dsum kind of approach does not meet my complex requirement. pl. suggest |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MY ARRAY FORMULA IS SLOW IF DATA LIST IS MORE THAN 10000R0WS
it would help if you posted the formula.. and explain how the data is organized (sorting, alpha(numeric) etc) but yes.. i'd say array formulas on multiple columns on 10000 rows of data takes processing time. also you do not say if the arrayformula is entered in an array of cells or just returns 1 value in 1 cell. possible scenarios: add a "helper" column with true/false formulae then do a simple sumif. write a custom function in VBA (possibly not fast enough..) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam S.DURAIVEL - ABU DHABI wrote : My array formula works very slower if the data list is more than 10000 rows and 200 columns. This situation i could not avoid also. Dsum kind of approach does not meet my complex requirement. pl. suggest |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula extends down to rows past data - very slow opening | Excel Discussion (Misc queries) | |||
Array in formula Vlookup changes when data list is added to | Excel Worksheet Functions | |||
Why is excel 2007 slow when selecting chart data from the formula | Charts and Charting in Excel | |||
Array formula that alphabetizes a list | Excel Worksheet Functions | |||
Slow Array formula or is there any alternative | Excel Programming |