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!
Bookmarks