Trying to use Data Analysis > Correlation tool, but keeps saying "Input range
must be a contiguous reference." CORREL() functions works Ok on same range.
What's happening?

HermH -

The only obvious way I can get that error message is to use a non-contiguous
range for the Input Range.

How is your data organized, what are you specifying for the Input Range, and
what version of Excel are you using?

- Mike
http://www.MikeMiddleton.com


"HermH" <(E-Mail Removed)> wrote in message
news:40504FF5-7DE0-48B5-BE9C-(E-Mail Removed)...
> Trying to use Data Analysis > Correlation tool, but keeps saying "Input
> range
> must be a contiguous reference." CORREL() functions works Ok on same
> range.
> What's happening?