+ Reply to Thread
Results 1 to 3 of 3

Delete multiple instances of duplicates

  1. 10-17-2008, 11:29 AM #1
    opg
    opg is offline
    Registered User
    Join Date
    07-11-2008
    Location
    Toronto
    Posts
    50

    Delete multiple instances of duplicates

    I have a database in which I have model references in column D along with data in each of the rows. I would like to execute a macro that will delete any duplicates but keep one of each distinct model numbers, so not to entirely delete all instances of duplicates, but to keep only one instance of it along with the entire row of information. Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 10-17-2008, 03:46 PM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    why is this in red?
    Reply With QuoteRegister To Reply
  3. 10-17-2008, 03:48 PM #3
    VBA Noob
    VBA Noob is offline
    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
    Cross poster. Awaiting OP to add link

    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 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)

Similar Threads

  1. Delete Newest Duplicates.
    By joshtreee in forum Excel General
    Replies: 0
    Last Post: 02-21-2008, 09:56 AM
  2. Delete oldest duplicates
    By Pindacko in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-20-2007, 10:18 PM
  3. lookup multiple instances
    By NathanR in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2007, 07:03 PM
  4. Delete Duplicates based on the Value of 2 Cells
    By wiredwrx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2006, 02:16 PM
  5. Finding multiple instances of the minimum value
    By mworth01 in forum Excel General
    Replies: 2
    Last Post: 11-10-2006, 05:17 PM

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