Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of "array" Formulas Allowed?
Excel2003 ...
ws1 = 30,000 records ws2 = 1,000 records ws3 = 1,000 records ws4 = 1,000 records ws2 = "unique" records from ws1 Col A (advanced Filter)-(format = Text) ws3 = "unique" records from ws1 Col B (advanced Filter)-(format = Text) ws4 = "unique" records from ws1 Col C (advanced Filter)-(format = Text) ws2, ws3 & ws4 are identical & each have 12 arrary Formula in Cols B thru M which target their respective Range on ws1 (Cols A, B, C) ... (array Formulas provided by T. Valko in a previous post & work great) Issue is ... With a small amount of data in ws1 all ws work perfect ... However, when ws1 contains 20,000 records (for example) then the array formula on ws3 fail to work ... they return the #N/A error. If I shrink the Range in the Formula on ws3 that the Formula need to look @ on ws1 then the Formula work, but I need the Range to be c2:c30000 just like ws1 & ws2. I may be able to reduce my Template Range on ws2, ws3 & ws4, but I need to keep my Range on ws1 @ 30,000 records. Above said ... Is there a "maximum" number of array formula that you can have? Or does anyone know what is happening here? My "Thanks" in advance to those of you that provide so many useful solutions on these boards ... Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
How to "return" the array element number in VBA | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable "arbitrary shape is not allowed when its elements cross a reference dimension" | Excel Discussion (Misc queries) | |||
"No more new fonts allowed in workbook" Can't add graph - Why? | Charts and Charting in Excel |