"sampling - input range must be a contiguous reference"

[Andreas]

Using the Data Analysis add-in, I'm trying to take a
random sample of a batch of records. Unfortunately, using
the Sampling tool, I keep getting the error message
above. There is no documentation of what this means in
the online help. Any idea what I can do to make this
thing work? I really don't want to have to use the
RANDBETWEEN function for a sample of this size.

Thanks!
Andreas

 

[Anon]

Using the Data Analysis add-in, I'm trying to take a
random sample of a batch of records. Unfortunately, using
the Sampling tool, I keep getting the error message
above. There is no documentation of what this means in
the online help. Any idea what I can do to make this
thing work? I really don't want to have to use the
RANDBETWEEN function for a sample of this size.

Thanks!
Andreas

A1,A2,A3 or A1:B10 are contiguous ranges, whereas A1,A3,A5 or A1:A3,B4 are
not. In simple language, the cells in the range must be next to each other,
in a simple block.