| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Correlation tool says Input range must be contiguous reference.
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Message - Input Range must be a contiguous Reference Help!!! | Excel Discussion (Misc queries) | |||
| Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
| Non-contiguous named range | Excel Discussion (Misc queries) | |||
| contiguous reference | Excel Discussion (Misc queries) | |||
| How do I reference non-contiguous columns in another sheet and th. | Excel Discussion (Misc queries) | |||
Linear Mode
