+ Reply to Thread
Results 1 to 4 of 4

Remove duplicates over multiple columns

  1. #1
    Registered User
    Join Date
    08-25-2016
    Location
    Des Moines, Iowa
    MS-Off Ver
    2010
    Posts
    7

    Remove duplicates over multiple columns

    I have two columns of data (A and B). Both columns have numerical values. The data looks similar to this.

    r A B
    1 1 2
    2 1 2
    3 1 3
    4 1 4
    5 2 3
    6 2 3
    7 2 4

    The only rows I want to remain are the ones that are unique in both columns. So for this example I want the rows remaining to be 1, 3, 4, 5, and 7. Since row 2 is the same as row 1 I want it removed. Since row 6 is the same as row 5 I want it removed. I'm not sure if I need a macro for this or what but anything would help as I have thousands of rows to remove.

    Thank you in advance!
    Zach

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Remove duplicates over multiple columns

    Select both columns, Data > Remove Duplicates.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Remove duplicates over multiple columns

    If columns don't have header try next code
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  4. #4
    Registered User
    Join Date
    08-25-2016
    Location
    Des Moines, Iowa
    MS-Off Ver
    2010
    Posts
    7

    Re: Remove duplicates over multiple columns

    This is why you trust Excel before you assume it can't do a simple task. I thought about that but assumed it would remove any and all duplicates instead of viewing each set of two values as an exclusive case. Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove duplicates from all columns.
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2016, 08:31 PM
  2. Remove duplicates across multiple columns
    By moishier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2016, 12:17 PM
  3. [SOLVED] Macro to copy data from multiple columns to new location and remove duplicates
    By excel151515 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2015, 04:21 PM
  4. Remove Duplicates in columns
    By naveenmarapaka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2014, 11:10 AM
  5. Replies: 2
    Last Post: 01-13-2014, 10:52 AM
  6. Compare 2 columns and remove duplicates in both columns when found
    By 1dtms in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2013, 02:19 AM
  7. Remove duplicates from multiple columns using VBA
    By rbs123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2013, 03:48 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1