Printable View
Hello all,
I need to delete the repeated items in Col. A
http://i142.photobucket.com/albums/r...0/61ad184c.jpg
(this is just a simplified version, my data can beup too 100 Rows.)
I have a thought of using double loops,but this didn't help as all items are treated as repeated items.
Now I have no idea abt this.:confused::confused::confused:
Help will be appreciated,thanks.
Well, first step I would sort the list. Then I would make a loop to check forward and if next item is the same as current, then delete it...
Which version of excel are you using? 2007 his this built in.
I'm using Excel 2000.
By the way, I finally I come with a stupid idea.
I add two columns of numbers next to this column.(Column B all=1, Column C all=1)
Write Double Loops on Column A, if have repeated items(Cells(a, 1) = Cells(b, 1)) then change the number to Column B to another number( say, 0)
After doing the double loop.
Check if the two Columns of numbers are still the same,
if not same, this means the items is repeated.
Lastly, delete the 2 columns of numbers.
My method is really stupid, but it works...
By the way, thanks again for your comments.