+ Reply to Thread
Results 1 to 2 of 2

Macro to filter based on identical column data as opposed to entire record

  1. #1
    Registered User
    Join Date
    08-27-2007
    Posts
    1

    Macro to filter based on identical column data as opposed to entire record

    Hello all,

    I'm relatively unfamiliar with macros and in need of assistance. I have a massive data set that we know includes many duplicates BUT the syntax for the data in certain fields does not necessarily identically match the same field in the duplicate record, thus the basic sort function is not working adequately. So I am trying to remove duplicate records based on identical data in the first 2 of 5 columns in the dataset. It is set up like this:

    A (Artist) B (Title) C (Claimant) D (SR #) E (Source)


    I am looking for a macro that will identify and remove duplicate records based on records with identical data in columns A and B.

    Any ideas? Thanks so much for any help you can provide.

  2. #2
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302

    Finding duplicates with fill-down formulas

    The following approach gives you flexibility without installing or modifying macros. Column DupNxt identifies records that are duplicated in the next row. Column Dup adds those records that have a duplicate in the prior row.

    If you select columns DupNxt and Dup, Copy, PasteSpecial:Values (in place), you freeze those values and can sort your data into order by duplicates. After inspection for unusual cases, you can delete all the 1's, keeping only the "last duplicate" 2's.

    The DupNxt formula is easy to change if you notice anomolies in your data, or want to apply different tests for what a "duplicate" is.

    Tell me if this helps.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    FrankBoston is the pen name for Andrew Garland, Lexington MA

+ 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