Correlation tool says Input range must be contiguous reference.

H

HermH

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?
 
M

Mike Middleton

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
 

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

Similar Threads

Using range names in functions 1
Correlation Analysis Tool - Output Range Error 0
Error Message - Input Range must be a contiguous Reference Help!!! 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
function cell range limitations 3
Cell Value as Named Range Reference 1
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0
Working on birthday "book" for my wife and having layout/editing trouble 0

Top