other than number

		Microsoft Office Forums > Microsoft Excel > Excel Programming
other than number

FAQ

Thread Tools

Display Modes

02-17-2012, 09:05 AM

Colin Legg Colin Legg is offline

Windows 7 32bit other than number

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:51 AM.