Thread: Correlation tool says Input range must be contiguous reference.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton[_2_] Mike Middleton[_2_] is offline
external usenet poster
  
Posts: 110
Default Correlation tool says Input range must be contiguous reference.
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" wrote in message
...
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?

Reply With QuoteReply With Quote