Thread: [Solved] Trying to count frequency
View Single Post
 
Old 07-30-2013, 01:58 PM
borninscorpio borninscorpio is offline Windows XP Office 2010 32bit
Novice
  
Join Date: Jul 2013
Posts: 3
borninscorpio is on a distinguished road
Default Trying to count frequency
Hello,

I have a spreadsheet with 270,000 words. Some words appear 1 or 2 times, and some appear 10,000. There are probably between 100,000 and 150,000 unique values.

I would like to get a count of each word. I have used this "=COUNTIF($A$1:$A$272145,A1)" formula, but it takes about two hours to calculate.

I am hoping someone has a suggestion as to how I can do this quicker.

I would sincerely appreciate it
Reply With Quote