Quote Originally Posted by ramananhrm View Post
I almost understood the logic. But im not sure.

Please try this file, & see if it works fine.
Hi, sorry for making this thread alive. I tried to used the excel sheet provided by ramananhrm but when i tried to used it for more than 2000+ url column b became blank. i think the formula doesn't work for will you please help me? i tried to change the $a:$2:$a$25 to $a$2:$a$2676 but its not working.