Quote:
Originally Posted by colin legg
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