+ Reply to Thread
Results 1 to 3 of 3

Highlight duplicate records based on multiple criteria

  1. #1
    Registered User
    Join Date
    06-11-2008
    Posts
    2

    Highlight duplicate records based on multiple criteria

    Hi everyone,

    I thought this would be super easy but I can't figure it out, and I can't seem to find any threads or support articles anywhere with this info...thats not to say one doesn't exist, I just can't find it!

    If anyone could give me some quick advice, I would be incredibly grateful!

    Using Excel 2007

    There are 3500 records with 50 columns of data each.
    I want to be able to highlight the duplicate entries based on 3 values across 3 columns being the same... I will attach an example.

    The columns I want to match are SUBJECT, COURSE, SECTION_NO.

    If you need to know the background, I had 2 worksheets from different time periods. I need to know the entries which are unique to each sheet... I do not need the entries that appear in both.
    I combined the sheets, and now just want to find the duplicates so I can delete them all.
    Advanced filter > unique records only, doesn't work because I need to remove all traces of any record which appears more than once.

    If anyone has any other solutions apart from the way which I would believe to be the most simple and quickest, I would definitely love to hear!!
    Thanks for your help!!!! I've been trying to do this for 2 days.
    Attached Files Attached Files
    Last edited by VBA Noob; 06-11-2008 at 03:19 PM.

  2. #2
    Registered User
    Join Date
    06-11-2008
    Posts
    2

    Smile

    So I just ended up putting it into Access, running a query to find the duplicates, and then running it as a 'delete query'.

    Way quicker. If there is still a way to do it in excel, I would be interested.
    Thanks!

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe using conditional formatting and a formula like

    http://www.contextures.com/xlCondFormat01.html

    =SUMPRODUCT(($B$2:$B$9=B2)*($C$2:$C$9=C2)*($D$2:$D$9=D2))>1
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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