| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Super slow table array formulas
I have a data entry sheet were
sheet 1 has the table array fromulas built down 25000 and accross about 12 columns. The table is about 500,000 rows of 12 colums. It was running ok, very sluggish) I have 2.888 G processor on the computer. But I stuck in a =if(countif( formula to check for duplicates. Now this sheets is running so slow it is almost unuseabel. any sujjestions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Super & Subscript | Excel Discussion (Misc queries) | |||
| Excel super slow start, answers? | Excel Discussion (Misc queries) | |||
| pivot table from recordset - very slow performance | Charts and Charting in Excel | |||
| Sumproduct formulas & slow response | Excel Worksheet Functions | |||
| Excel formulas are slow to update | Excel Worksheet Functions | |||
![Dylan @ UAFC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
