+ Reply to Thread
Results 1 to 3 of 3

Avoid Duplicate Records

  1. #1
    Registered User
    Join Date
    12-01-2008
    Location
    India
    MS-Off Ver
    Microsoft 365 Enterprise - Excel version2301
    Posts
    63

    Avoid Duplicate Records

    In the attached Sheet if there is any repeated name I can select the unique records by pulling up the formula (=IF(COUNTIF(C$1:C2,C2)=1,MAX(A$1:A1)+1,"") in column A pulling it up to get the serial number , and delete the blank records by selecting blanks through Auto Filter. The Challenge is I want have only those unique records which have the minimum amount, as final output given in sheet 2. Every time i get a new piece of data which contains some of the old entries (Name) with reduced amount and some of the new entries, i want keep the old entries (Name) with reduced amount and new entries (Name) with new amount. Please help , Thanks in advance.
    Attached Files Attached Files
    Last edited by VBA Noob; 12-27-2008 at 11:56 AM. Reason: title

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251
    I made a formula that shows what rows you can delete.

    =IF(SMALL(IF(C2=$C$2:$C$14,$D$2:$D$14,"");1)<>D2,"Remove this row","")

    See file attched.
    Attached Files Attached Files

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    before i go on you wont be able to "keep" old records unless you have some sort of date, even then its probably best if you apply a function to each list you get then compare them somehow.

+ 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