Thread: [Solved] other than number
View Single Post
 
Old 02-17-2012, 09:05 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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?
__________________
Colin

RAD Excel Blog
Reply With Quote