Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Correlation tool says Input range must be contiguous reference.

1,444 views
Skip to first unread message

HermH

unread,
Apr 27, 2010, 2:41:02 PM4/27/10
to
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?

Mike Middleton

unread,
Apr 27, 2010, 7:06:06 PM4/27/10
to
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" <He...@discussions.microsoft.com> wrote in message
news:40504FF5-7DE0-48B5...@microsoft.com...

0 new messages