1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Delete duplicates in Excel 2007

Discussion in 'Business Applications' started by cantab65, Apr 21, 2010.

Thread Status:
Not open for further replies.
  1. cantab65

    cantab65 Thread Starter

    Mar 25, 2010

    I've got 2 columns of data in Excel 2007 that need sorting. There are some duplicates in both columns i.e. some column A data is duplicated in column B and vice versa. Is there an easy way to find and delete the duplicates in both columns?

  2. Keebellah

    Keebellah Trusted Advisor

    Mar 27, 2008
    First Name:
    How is you vba knowledge?
    You could write a macro to do this.
    Two things, if the columns are not related you could sort one column first and then the other column, that way the duplicates are inmediately visible.
    You could also record a macro that does the following:

    Start macro recorder
    Go to Data extended Filter
    Select the first column to sort
    choose to copy only unique values to another location on the sheet
    when finsihed repeat for the seond column and choose a new location next to the previous one.
    Then all you have to do is clear the first two columns and move both new columns to the same location.
    Sounds difficult? Try it on a test sheet and see what happens.
    You can then check the vba editor and see how the macro works to help you along.

    If you want I'll try and attach a sample file for you.
  3. etaf

    etaf Moderator

    Oct 2, 2003
    First Name:
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/918440

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice