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

data is like this
1 4 a
1 - b
1 - c
2 5 d
3 7 e
1 4 a
1 - b
1 - c
4 8 f
5 2 g
1 4 a
1 - b
1 - c
6 1 h

in this 1 one repeating like my data i want to delete repeated

So, you are saying that the following values are repeated:

1 10 a
1 b
1 c
2 5 d
3 7 e
1 10 a
1 b
1 c
4 8 f
5 2 g
1 10 a
1 b
1 c
6 1 h


So you want to delete the red ones. Is that correct?

yes extractly see in the attachment gap and all other then names