+ Reply to Thread
Results 1 to 7 of 7

Delete duplicate values and mantening unique values

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Delete duplicate values and mantening unique values

    I need help in identifing duplicates values and those values most be deleted and in keeping the unique one between two columns ex.

    Column a column b
    23 36
    35 23
    45 95
    68 105
    95 85
    85 75
    75 35



    results should be = to

    column a column b
    45 36
    68 23
    105

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,398

    Re: Delete duplicate values and mantening unique values

    See the attached file.

    I used helpcolumn (see the yellow cells)

    The result is in the green cells.

    P.s. the number 23 in your example is also duplicated.
    Last edited by oeldere; 01-18-2013 at 03:29 PM. Reason: P.s. etc.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Delete duplicate values and mantening unique values

    wow thx for the fast reply, i was looking for a vba steps

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,398

    Re: Delete duplicate values and mantening unique values

    you can record the manual actions with the macro-recorder.

    then you get the VBA code.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Delete duplicate values and mantening unique values

    Hi Coletto,

    Try this:

    Please Login or Register  to view this content.
    Directions for running the routine(s) just supplied

    Copy the code to the clipboard

    Press ALT + F11 to open the Visual Basic Editor.

    Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

    Select “Module” from the Insert menu

    Type "Option Explicit" then paste the code into the white space on the right

    With the cursor between Sub and End Sub press F5 (F8 to Single Step)

    OR

    Press ALT + Q to close the code window.

    Press ALT + F8 then double click on the macro name
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  6. #6
    Registered User
    Join Date
    10-10-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Delete duplicate values and mantening unique values

    wow, you guys are the best....

    thx a lot it worked for me and is perfect just the way i wanted in a range of A:A and B:B cuz i have over 300,000 records to compared to

    really thx to both of you guys

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Delete duplicate values and mantening unique values

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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