|
|
#1
07-30-2013, 01:58 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| 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 |
 Count By Color
|
beb1227 | Excel | 4 | 06-15-2011 08:46 AM |
Windows XP 
Office 2010 32bit
Threaded Mode