Thread
: [Solved]
formula taking long time to distinct word
View Single Post
03-15-2012, 09:22 PM
gsrikanth
Windows XP
Office XP
Competent Performer
Join Date: Dec 2011
Posts: 133
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))}
gsrikanth
View Public Profile
Find all posts by gsrikanth