+ Reply to Thread
Results 1 to 15 of 15

Removing Duplicate Data Sets

  1. #1
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Removing Duplicate Data Sets

    Hi all,

    I'm trying to create a macro that runs through data sets and removes duplicate entries. I have been sucessful with removing single entries but I can't figure out how to compare ranges and remove those that are the same. I have attached a file. Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    1. Are the "ranges" always in the same places on the sheet ?
    2. Is the order of entries in the "ranges" (to be compared) always the same ?

  3. #3
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Re: Removing Duplicate Data Sets

    The ranges will be in the same place. The order of the ranges may change. If possible I only want exact duplicates to be removed.

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    Quote Originally Posted by fullmetalchrono View Post
    ... The order of the ranges may change ...
    ... order of entries (Bananas, Pears, Apples, etc.) in the "ranges" ... not order of the ranges ...
    so .. Is the order of entries (Bananas, Pears, Apples, etc.) in the ranges always the same ?

  5. #5
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Re: Removing Duplicate Data Sets

    Sorry. I mistyped. I meant that the order of entries may change. I just want the macro to remove completely identical ranges of data, not ones that are in a different order.

  6. #6
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    How big/large will the individual (compared) ranges be, how many rows ?

  7. #7
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Re: Removing Duplicate Data Sets

    I would say a maximum of 20.

  8. #8
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    Try:
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Re: Removing Duplicate Data Sets

    Thanks. That works really well. How could I change the results destination here? Say for example further down?

  10. #10
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    The result row number ==> Const rsltRow = 10

  11. #11
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Re: Removing Duplicate Data Sets

    Is there any way I could get the tables to display vertically rather than horizontally?

  12. #12
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    Probably 'yes' - show an example of data layout after transposition.

  13. #13
    Registered User
    Join Date
    12-08-2019
    Location
    Shrewsbury
    MS-Off Ver
    2016
    Posts
    30

    Re: Removing Duplicate Data Sets

    Something like this.
    Attached Files Attached Files

  14. #14
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,365

    Re: Removing Duplicate Data Sets

    Different method used.
    Eliminate the duplicate when both column A & B are identical.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  15. #15
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,632

    Re: Removing Duplicate Data Sets

    Quote Originally Posted by fullmetalchrono View Post
    ... to display vertically ...
    E.g.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-26-2014, 08:24 PM
  2. Remove duplicate values of sets of data vertically
    By acojan in forum Excel General
    Replies: 14
    Last Post: 08-28-2014, 08:23 PM
  3. Replies: 2
    Last Post: 08-30-2013, 06:30 AM
  4. [SOLVED] Removing unmatched data from two time series data sets!
    By ImranEF in forum Excel General
    Replies: 4
    Last Post: 07-26-2013, 11:13 PM
  5. [SOLVED] Duplicate data sets and need formula to condense
    By paulbeav in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2013, 10:58 AM
  6. How to Remove Both Sets of Duplicate Data
    By sstephen123 in forum Excel General
    Replies: 0
    Last Post: 11-10-2011, 09:27 AM
  7. How do I delete both sets of duplicate data?
    By Superpreciosa in forum Excel General
    Replies: 1
    Last Post: 07-24-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1