Your sample file is now different to the original and it contains information which I do not understand. I also do not understand what "501 is repeating only get that once" means. There were no 501 numbers in your original file.

Unless you can explain your question clearly I will not be able to help you.

I also notice that you have been given several answers to this same question over at MrExcel.
http://www.mrexcel.com/forum/showthread.php?t=614432