+ Reply to Thread
Results 1 to 6 of 6

Removing duplicate in from two columns not in order.

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2007
    Posts
    3

    Removing duplicate in from two columns not in order.

    Hi experts,

    I have trying to remove duplicate value for two columns which are not in order since long time. I have listed an example for the purpose. Two rows contains same information in different columns. I just wanted to have one row and remove the other with same information. Need a quick help.

    AA AA
    500135 500136
    500136 500135
    500137 500138
    500138 500137
    500191 500192
    500192 500191
    500277 500278
    500278 500277
    500413 500414
    500414 500413

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Removing duplicate in from two columns not in order.

    Why you don't just delete the second column?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    10-02-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Removing duplicate in from two columns not in order.

    Removing second column will be a manual work for huge data and all the rows dont have duplications.

  4. #4
    Registered User
    Join Date
    10-02-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Removing duplicate in from two columns not in order.

    These are the pair numbers, deleting one column will not let me know which number is paired to what.. yes but deleting whole row which contains same paring data will be useful.

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Removing duplicate in from two columns not in order.

    Assuming that you date start in A2, in C2 and copy down you can use this.

    =A2=B2

    Then filter by true in column C, you'll get all cases that data are same in both columns.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,817

    Re: Removing duplicate in from two columns not in order.

    You can find the answer here : Create a list of unique distinct numbers

+ 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] Removing Two Highest Values, Columns not in order
    By dmeyer1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2012, 01:01 PM
  2. Removing Duplicate Rows based on 2 columns
    By metalpoker in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 10-14-2011, 05:28 AM
  3. Removing Duplicate Values - 2 Columns
    By hpaum99 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-27-2010, 12:00 PM
  4. Replies: 1
    Last Post: 04-01-2005, 07:06 PM

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