Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Editing duplicate rows (XP)

    I have several spreadsheets to combine. I am copying each worksheet and then adding it to the bottom of the spreadsheet, and then doing a sort to see if any duplicates exist. Right now, I am manually deleting any duplicate rows. Is there an easier way to pull all of the unique data out? This spreadsheet is thousands of rows. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing duplicate rows (XP)

    Use Advanced Filter, or look at this very recent thread: <post#=344974>post 344974</post#> plus reply.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing duplicate rows (XP)

    See my reply to your other post. I still need assistance with macro.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing duplicate rows (XP)

    Have you tried Data | Filter | Advanced Filter..., Copy to Another Location and Unique Values Only? No macro needed at all.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing duplicate rows (XP)

    I think the advanced filter will work for me! Thanks!

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing duplicate rows (XP)

    Getting error when try to copy to another location. See attached. Getting around it when I copy just visible cells and move to another location

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing duplicate rows (XP)

    With Advanced Filter, you can only copy to another location on the same worksheet. Afterwards, you can copy the result to another worksheet. Copying visible cells only will also work.

Posting Permissions

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