View Single Post
 
Old 03-15-2012, 09:22 PM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default 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))}
Reply With Quote