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 - 
=COUNTIF($A$2:A$800000,A2)
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