View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dylan @ UAFC[_2_] Dylan @ UAFC[_2_] is offline
external usenet poster
 
Posts: 76
Default 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