Any Way To Speed Up Calculations

Hi

I have an excel 2013 (64 bit) workbook having nearly 800K records where I need to count the occurrence of each company name in the company column

Using the following formula to run the calculation -

Please Login or Register  to view this content.

The issue is, it is taking a very long time to process this. I understand there is massive amount of data that needs to be processed, but I was wondering if there was any other formula which would do the same thing but faster?

My PC configuration is nothing great but not too bad either (I think) - Having a hexa core CPU with 8 Gigs of RAM

Thanks