"sampling - input range must be a contiguous reference"


A

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
 
Ad

Advertisements

A

Anon

Andreas said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top