CORREL function with a constant array

		Microsoft Office Forums > Microsoft Excel > Excel
CORREL function with a constant array

FAQ

Thread Tools

Display Modes

01-28-2013, 06:11 PM

j2b3

Windows Vista CORREL function with a constant array

Office 2010 32bit

Novice

Join Date: Jul 2012

Posts: 4

CORREL function with a constant array

I am trying to formulate a spreadsheet and calculate correlation between one column and around 300 others. I don't want to to it all by hand, and so I was wondering if there is any way to make one column "stick" in the formula as array 1 and then add the current column that the function is in as the second array:

A B C D E F G

(A,G) (B,G) (C,G) (D,G) (E,G) (F,G)

Thanks!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Keep cell in formula constant	jprt68	Excel	1	06-26-2012 08:31 AM
How to reserve an array in a public function?	tinfanide	Word VBA	2	02-27-2012 06:51 AM
Constant PopUp windows in Outlook!!!	arkoh	Outlook	0	12-05-2011 10:52 AM
Keeping the top row constant in Excel	MSmand	Excel	2	07-13-2011 01:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 AM.