Can you break up your ranges into smaller groups. I had to correct one for a
client recently where he was using a VLookup for 65000 rows. If desired, I
will take a look if you send to my address below.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dylan @ UAFC" wrote in message
...
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