Closed Thread
Results 1 to 4 of 4

Removing Duplicate Samples Regardless of Order

  1. #1
    Registered User
    Join Date
    10-12-2019
    Location
    Jersey City, NJ
    MS-Off Ver
    Microsoft Professional Plus 2016
    Posts
    2

    Removing Duplicate Samples Regardless of Order

    Hello,

    Please see the attached file. I have several samples of data shown in columns C-L. In my file, Sample 3, and Sample 5 are duplicates of Sample 1. Sample 3 contains the same values as sample 1, but in a different order. Sample 5 contains the same values as sample 1; they are in the same order. Sample 3 and Sample 5 need to be removed because they are duplicates. I am comparing the entire columns to one another. How could I remove the duplicate samples and others that may exist? I'd like something that can be easily used on hundreds of samples.

    Note: There could be more duplicates. I just manually inserted two duplicate samples into this set of random samples.

    Other information that might help: Each sample is created without replacement (meaning each value in the population can only appear once in a given sample).

    Thank you in advance for taking the time to help!
    Attached Files Attached Files
    Last edited by TheSharp; 10-12-2019 at 07:59 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    16,016

    Re: Removing Duplicate Samples Regardless of Order

    Can you explain specifically using your example what you wish to happen. Your explanation is a little vague and can be interpreted in several ways. What are you matching your duplicates against? What does column A have to do with the table shown? Would be very beneficial if you show a mocked up version of what your expected results would look like with an explanation of why. Are you matching entire columns or individual cells. Very confusing.

  3. #3
    Registered User
    Join Date
    10-12-2019
    Location
    Jersey City, NJ
    MS-Off Ver
    Microsoft Professional Plus 2016
    Posts
    2

    Re: Removing Duplicate Samples Regardless of Order

    Quote Originally Posted by alansidman View Post
    Can you explain specifically using your example what you wish to happen. Your explanation is a little vague and can be interpreted in several ways. What are you matching your duplicates against? What does column A have to do with the table shown? Would be very beneficial if you show a mocked up version of what your expected results would look like with an explanation of why. Are you matching entire columns or individual cells. Very confusing.
    Sorry for not conveying my question clear enough. I added a revised file with notes that hopefully has what you need. I'll also try to answer your questions here.

    1. I made before and after tabs.

    2. Here's a simpler example of what I'm defining as a duplicate. Sample 2 and 3 need to be removed because they are duplicates.

    Sample 1:
    Apple
    Orange
    Pear

    Sample 2 (duplicate of sample 1):
    Pear
    Apple
    Orange

    Sample 3 (also a duplicate of sample 1):
    Apple
    Orange
    Pear

    Sample 4 (not a duplicate of any sample):
    Apple
    Pear
    Watermelon

    3. I am matching entire columns.

    4. I am trying to remove every sample that is a duplicate of another sample.

    Please let me know if you need anything else to be clarified. Thank you!

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,954

    Re: Removing Duplicate Samples Regardless of Order

    Closed to be re-posted in Commercial Services.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

Closed 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