|
|
#1
03-15-2012, 09:22 PM
|
|||
|
|||
formula taking long time to distinct word
i get distinct word with this forumula
i have 30,000 rows with below forumula taking lot of time with draging to all cell {=INDEX(List,MATCH(0,COUNTIF($b$1:b1,List),0))} 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
| MS word taking over file extensions | jakes | Word | 0 | 10-22-2010 01:35 AM |
| Adding a long column of time increments in seconds | klippert | Excel | 1 | 09-18-2010 12:26 AM |
| Word :mac 2008 is crashing all day long... | P. Alkuin | Word | 4 | 04-20-2010 10:47 PM |
| WORD taking up entire CPU!!! | pureride | Word | 0 | 03-28-2008 09:46 AM |
formula taking long time to distinct word
Windows XP 
Office XP
Threaded Mode