other than number

Colin Legg · #1 02-17-2012, 09:05 AM

Quote:

data is like this
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

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?

gsrikanth · #2 02-17-2012, 09:06 AM

Quote:

Originally Posted by colin legg

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
number to text	acki	Excel	1	01-26-2012 07:47 AM
convert to number	gsrikanth	Excel	1	01-09-2012 01:01 AM
number change 11 to 12	uoume	Office	0	10-30-2011 06:33 PM
Mailing: how to make the "page number" in Word is the same as "row number" in excel w	Jamal NUMAN	Word	1	09-03-2011 11:37 AM
Last Number in a Column	paulrm906	Excel	1	12-05-2008 07:51 PM