Thread: [Solved] other than number
View Single Post
 
Old 02-17-2012, 08:55 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by colin legg View Post
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
Reply With Quote