Quote:
501 is repeating
491 is repeating
only that get once
|
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