Results 1 to 5 of 5

Thread: Excel help - easy removal of duplicate rows

  1. #1
    Basically lazy robd's Avatar
    Join Date
    May 2005
    Location
    Nr Cambridge
    Posts
    3,696
    Rep Power
    12

    Excel help - easy removal of duplicate rows

    Anyone point me in the direction of some advice on quick easy, deletion of duplicate rows in an Excel worksheet?

  2. #2
    Registered User
    Join Date
    Mar 2003
    Location
    bedford
    Posts
    4,899
    Rep Power
    13

    Re: Excel help - easy removal of duplicate rows


  3. #3
    Registered User
    Join Date
    Sep 2006
    Location
    South
    Posts
    5,424
    Blog Entries
    22
    Rep Power
    11

    Re: Excel help - easy removal of duplicate rows

    Quote Originally Posted by robd View Post
    Anyone point me in the direction of some advice on quick easy, deletion of duplicate rows in an Excel worksheet?

    1. Select all the data you're working with.
    2. Go to Data - Filter - Advanced Filter.
    3. Check the "Unique records only" box.
    4. Click OK.
      All the duplicates are now hidden; to get rid:
    5. Go to Edit - Office Clipboard.
    6. Select the displayed unique records and copy them.
    7. Go to Data - Filter - Show all.
    8. Delete it all.
    9. Select the start cell.
    10. Click the copied item from step 6 on the clipboard to paste it back in.

    Don't forget to do this on a copy of the spreadsheet in case it goes wrong and you can't recover your deleted data.

  4. #4
    Basically lazy robd's Avatar
    Join Date
    May 2005
    Location
    Nr Cambridge
    Posts
    3,696
    Rep Power
    12

    Re: Excel help - easy removal of duplicate rows

    Thanks for suggestions so far.

    This is actually for a pretty tech-unsavvy colleague. Ideally she'd just like a big 'remove Duplicates' button to press but Excel doesn't seem to have that There are some macros in the google links that look like they might do the job assuming I can get them associated to her Excel profile rather than individual worksheets.

    I have used the filter method before and will see if it works for her too though some of the spreadsheets are pretty massive so memory capacity may be an issue.

  5. #5
    Meglio del Cioccolato Demo
    Join Date
    Jan 2003
    Location
    Edinburgh
    Posts
    1,541
    Rep Power
    11

    Re: Excel help - easy removal of duplicate rows

    When I had to remove duplicates in a big excel file I always found it easier to import the file in Access and do it from there.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calling Excel Gurus.....
    By robd in forum Geeks' Corner
    Replies: 13
    Last Post: 5th-February-2009, 10:09 AM
  2. Excel sort & delete question....
    By Will in forum Geeks' Corner
    Replies: 22
    Last Post: 26th-May-2007, 11:14 PM
  3. excel
    By under par in forum Geeks' Corner
    Replies: 12
    Last Post: 8th-March-2007, 10:51 PM
  4. Easy Tiger
    By fletch in forum Chit Chat
    Replies: 2
    Last Post: 24th-August-2006, 12:41 PM
  5. The Easy, Foxy, Dirty, Suxby Tour 16th - 19th June 2006
    By Spice 'n' Easy in forum Social events
    Replies: 79
    Last Post: 22nd-June-2006, 01:31 PM

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

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