![]() |
#1
|
|||
|
|||
![]()
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 ![]() ![]() ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Count | Richtriebe | Word | 1 | 04-20-2013 11:09 AM |
Frequency of a name | bryant03 | Excel | 1 | 06-27-2012 10:21 AM |
How to set frequency of Send?/Receive in Outlook 2010 | mikepla | Outlook | 4 | 11-03-2011 06:50 AM |
How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |
![]() |
beb1227 | Excel | 4 | 06-15-2011 08:46 AM |