Deleting Repeated data

[Guest]

Hello people
I have two columns of repeated data like the following
1 aa
1 aa
2 bb
2 bb
2 bb
3 cc
3 cc
and I am trying to delete the repeated ones and leave only just one data like
1 aa
2 bb
3 cc
So is there any quick way to do that?

 

[Yogi Anand]

Assuming you really only have 2 columns:

In c1, type: Dupes
In c2, type: =a2&b2
In c3, type: =if(a3&b3=c2,"dupe","")

Copy c3 down all the rest of the rows.

Select only the populated cells in column 3. Copy them. Don't move cursor. Hit Edit-Paste special, Values, Ok.
Click on C2 and hit the ZA (descending) sort button. Delete all rows that say *dupe*. Re-sort how you like.

Hi Anonymous and Dreamboat:
With the setup provided by Dreamboat, I suggest the following change ...
in cell C1 Dupes

then in cell C2 =if(b1=b2,"Dupe",b2)

and then copy/drag down as far a syou need to

and you will end up with:
1 aa aa
1 aa Dupe
2 bb bb
2 bb Dupe
2 bb Dupe
3 cc cc
3 cc Dupe

 

[Chris Davison]

also, advanced filter / copy unique values / to another location is an option

(depending on available worksheet space, obviously)



_________________
Hope this helps,
Chris



edit : blimey Yogi.... this original question was AGES old !!!!
This message was edited by Chris Davison on 2002-04-05 20:05

 

[Yogi Anand]

Hey Buddy Chris:
You are right I did see this question before, but just as I was ready to post, my network went kaput, so it was several hours later that I got to it again ... You are a tough Task Master man!

 

[Chris Davison]

On 2002-04-05 20:12, Yogi Anand wrote:
Hey Buddy Chris:
You are right I did see this question before, but just as I was ready to post, my network went kaput, so it was several hours later that I got to it again ... You are a tough Task Master man!

weeks more like.... it was posted in early March !

actually, I just noticed someone bumped it to the top of our listings with a blank post

DOHHHH
(_8 ()

 

[Yogi Anand]

Hi Chris:
You are right again ... of course! Anyway the Apr-5-02 entry just before had brought it to my attention!
Cheers