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
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,142

    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.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  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
    MS365 2209 64-bit
    Posts
    21,463

    Re: Removing Duplicate Samples Regardless of Order

    Closed to be re-posted in Commercial Services.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing Duplicate Returns on Calculations (Not Duplicate Lines)
    By TeamOSupremeO in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2018, 09:28 AM
  2. Removing a preset order
    By elly_mac in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2016, 08:30 PM
  3. [SOLVED] Reverse Order while removing certain text
    By bloodlvst in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2016, 01:31 AM
  4. Removing Merged cells keeping entries order
    By Odracir in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2015, 02:21 AM
  5. [SOLVED] Consolidate grocery order by removing unused rows
    By Jamesera27 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-30-2014, 11:33 AM
  6. Removing duplicate in from two columns not in order.
    By bisalk in forum Excel General
    Replies: 5
    Last Post: 10-02-2013, 03:24 AM
  7. [SOLVED] Removing Two Highest Values, Columns not in order
    By dmeyer1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2012, 01:01 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