+ Reply to Thread
Results 1 to 4 of 4

Find and remove duplicates?

  1. 04-30-2009, 04:28 AM #1
    famico78
    famico78 is offline
    Registered User
    Join Date
    10-15-2008
    Location
    Lincolnshire
    Posts
    53

    Find and remove duplicates?

    I have been toying with the advanced filter to remove duplicates from my records, but I am having problems where if I have a customer number entered multiple times for a different date and payment received, it removes all but one record.
    The data contains a customer number, date, amount, premium, ID and commission and more..

    10234 12-May-08 £530.59 £530.59 8926534 £0.00
    12345 14-May-08 £224.10 £466.16 8926534 £0.00
    12345 14-May-08 £224.10 £466.16 8926534 £0.00
    12345 19-May-08 £242.06 £0.00 8926534 £0.00
    12345 19-May-08 £242.06 £0.00 8926534 £0.00
    26456 14-May-08 £189.00 £189.00 8926534 £0.00
    34567 15-May-08 £201.88 £201.88 8926534 £0.00
    45678 15-May-08 £173.42 £173.42 8926534 £0.00
    56789 19-May-08 £326.33 £326.33 8926534 £0.00

    Using 12345 as an example, when I filter it removes all but one record for 12345. I need to see all payments received monthly bar those duplicates.

    Please help!
    Reply With QuoteRegister To Reply
  2. 04-30-2009, 04:45 AM #2
    ElmerS
    ElmerS is offline
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Find and remove duplicates?

    I Hope the "Advanced filter" - proposed in the attached picture - is the solution to your question.

    Elm
    Attached Images Attached Images
    Last edited by ElmerS; 04-30-2009 at 05:42 AM.
    Reply With QuoteRegister To Reply
  3. 04-30-2009, 06:16 AM #3
    JONvdHeyden
    JONvdHeyden is offline
    Forum Contributor
    Join Date
    04-16-2009
    Location
    Stellenbosch, South Africa
    MS-Off Ver
    Excel 2003; Excel 2007; Excel 2010; Excel 2013
    Posts
    136

    Re: Find and remove duplicates?

    You could use a macro. Add this to a module in your workbook. To run hit ALT+F8 and choose Clear_Dupes from the dialog.

    Note: This assumes that you have column labels above your data table. Also assumes that your table does not have further data to the right of it. I recommend you create a back-up before running this as it does delete rows and it cannot be undone. Please be careful not to include your column labels when promted to select your data table.

    Please Login or Register  to view this content.
    Regards

    Jon (Excel 2003, 2007, 2010, 2013)
    Reply With QuoteRegister To Reply
  4. 04-30-2009, 07:38 AM #4
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Find and remove duplicates?

    Hi, Just an Alternative bit of code.
    Assumed your Data in columns "A:F" starting row 2.
    Results in cell "H2" On. NB:- Change "Results" Range Address at end of code, to suit you. (Will overwrite Data if required)
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1