+ Reply to Thread
Results 1 to 3 of 3

Delete duplicates value combinations from two columns

  1. #1
    Registered User
    Join Date
    03-29-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Delete duplicates value combinations from two columns

    Hi everyone,

    I hope someone can help me out. I have two columns of data, one with an ID # and the other one with a date. Some ID# + date combinations are repeated and I need to delete the duplicates. Here is a visual:

    ID# date
    54 19720211
    54 19720211
    54 19810512
    67 19590312
    89 19931104
    89 19931104

    I need to keep only unique ID/date combinations. I would need the final list to look like this:

    ID# Date
    54 19720211
    54 19810512
    67 19590312
    89 19931104

    Any help is appreciated, thanks!

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,739

    Re: Delete duplicates value combinations from two columns

    if you use a new column and do this

    assuming ID# is in column A and Date in column B

    in C column put
    =A2&B2
    copy down
    now in D2
    put =COUNTIF($C$3:$C$11,C3)>1

    this will show all the duplicated values - (original and any duplicates) as TRUE

    also depending on version of exel - you could use remove duplicates
    DATA>remove duplicates

  3. #3
    Registered User
    Join Date
    03-29-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Delete duplicates value combinations from two columns

    Thanks! I ended up highlighting all columns, going to Advanced Filter and clicking on unique records only.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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