Forum Discussion
Remove Duplicates from Random Sample Prior to Sampling
I am using the sampling tool in the data analysis toolpak add-in to create a random sample. In this example I had a population of 116 and need exactly 29 unique samples chosen from this 116. I do not...
Try:
=INDEX(SORTBY(A2:A116, RANDARRAY(ROWS(A2:A116))), SEQUENCE(29))
A2:A116 is the range of your data, and
29 is your desired sample size
RANDARRAY function generate an array of random numbers with the same number of rows as your data.
SORTBY function to sort your data based on the random numbers generated by RANDARRAY. It will shuffle your data.
=INDEX(SORTBY(A2:A116, RANDARRAY(ROWS(A2:A116))), SEQUENCE(29))
A2:A116 is the range of your data, and
29 is your desired sample size
RANDARRAY function generate an array of random numbers with the same number of rows as your data.
SORTBY function to sort your data based on the random numbers generated by RANDARRAY. It will shuffle your data.