Multi Core Processor with Max Memory

[amerifax]

If I purchase a motherboard that uses a Hex-Core Processor (I think that is the proper term) and max out the Memory on the motherboard, will that enable me to process extremely large files in Excel or Access, just for example.

I have files with a Million plus records and they are just going to keep growing. I need to be able to handle the data processing without waiting 20-30 minutes for a formula to calculate.

Any suggestions or help would be appreciated.

Thanks,

Bob

 

[amerifax]

MrKowz

Should my formula look like this??

=IF(COUNTIF(M:M,M2)-1,"X","")

Then change the custom number format after running the formula?

Just wanted to make sure before I ran it.

Thanks for your help so far, I really appreciate it.

Bob

 

[MrKowz]

No, we are eliminating the IF statement altogether. Make the formula:

=COUNTIF(M:M,M2)-1

And apply the custom format.

What this does, is it actually creates a series of numbers that are either 0 or greater than 0.

 

[Norie]

Bob

I don't know enough about your setup to suggest something in particular.

It just seems to be far too much data for Excel to deal with efficiently.

Pretty sure some sort of database would be involved.

 

[amerifax]

>>MrKowz<<

It seems I'm over loading Excel. I get a message to shorten the about of records I'm tiring to process.
Excel "Cannot complete task with available resources. Choose less data or close other programs."

Can I run several thousand records at a time. In other words is the formula good at one line at a time. That would let me past and run several times in the column tell I get to the bottom.

 

[Norie]

Bob

If you are dealing with millions of records I don't think Excel it's the best tool for the job.

Do you have anything else you can use?

 

[amerifax]

Do you have anything else you can use?

I wish I did. Can you give me any ideas?

 

[amerifax]

>>Norie<<
I've been hearing then at. But I don't have a clue as to what else is out there. I am all ears or should I say all eyes.

Would it possibly be something like Oracle. which is a database. I do have to agree. We are definitely pushing the limits of Excel. One of my calculation started Friday four o'clock in the after noon and here it is Saturday morning 2:22 AM and it's at 89%. I haven't had days like this since dBase III which used to take three days, which now takes an hour and a half to run my bread and butter program.
Bob