Deleting Repeated data - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Deleting Repeated data

  1. #11
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     

    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

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #13
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  4. #14
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ()




  5. #15
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com