I ran sample on a list of 700 numbers. The numbers were sequential, however.
I also got multiple hits. It appears that this tool samples with
replacement. That is each sample is drawn from the population independently
from previous draws.

This means that not only is it possible for a number to come up more than
once, it is statistically inevitable.

One approach would be to select, say, 270 or more samples. Then use

Data Filter Advanced Filter...
and select unique records only. Keep the first 250.


Good Luck
--
Gary's Student


"David" wrote:

I have a list of 2730 numbers in a worksheet, used Sampling in the Tool menu
area, my question is that it picks some of the numbers twice and puts that as
a part of the sample. I need a output of 250, I get the 250, but with some
duplications. Any help you can provide would be greatly appreciated.