Correlation with multiple criteria

[tjkramer]

I am trying to find the correlation of two columns of data if multiple conditions are met -- almost like a "sumifs" function, except a "CorrelIfs" function.

Column A = dates (dd/mm/yy)
Column B = Quarter (1-4)
Column C = Year (yyyy)
Column D = daily natural gas prices for 10 years
Column E = daily power prices for 10 years
Cell F1 = Start Year
Cell F2 = End Year
Cell F3 = Quarter

I am trying to make the correlation function be dynamic, so that I can change the start date in F1, the End Date in F2 and the Quarter in F3. Specifically, I'd like to be able to type 2015 in F1, 2017 in F2 and Q3 in F3 and get the correlation of natural gas (Column D) to power (Column E) from 2015 thru 2017 for just Q3 during that time period. Then I need to be able to change the start year and/or End Year and/or Quarter.

I can do this for changing start and stop dates, but I do not know how to introduce the changing Quarter cell. For the changing start/stop dates:
=Correl(Index($D:$D, Match ($F$1,$C:$C,0)): Index($D:$D, Match($F$2,$C:$C,0)), Index($E:$E, Match($F$1,$E:$E,0)): Index($E:$E,match($F$2,$C:$C,0))) works for me for calculating the correlations for the specific years. But I do not know how or where to introduce the changing "Quarter" variable (cell F3) into this formula.

Any help will be greatly appreciated.
Many thanks,
TK

 

[DRSteele]

What version of Excel do you have? If you have updated software (i.e., MS 365 Monthly Channel) you can use function FILTER to report the arrays that go inside function CORREL. Otherwise, I remember it to be a complex task.

 

[tjkramer]

Thank you for the prompt reply. I am using Excel 2013. I am unfamiliar with the function FILTER.

 

[DRSteele]

Function FILTER is only available in up-to-date software.

If you install the xl2bb tool, you can upload some sample data and we'll try to do it ye olde scuul method.

 

[tjkramer]

Thanks in advance for your help and patience. And apologies for how obtuse I may be in trying to solve this.
I've downloaded the xl2bb Add-In (which I've never used before) and it is now showing up in my Excel ribbon.

 

[DRSteele]

No need for apologies. We're here to help.

 

[tjkramer]

Much appreciated. What can I do to make this easier for you and what should I do next? This data file is a demon, with 10 years of commodity prices for 24 different commodities.

 

[DRSteele]

Upload some sample data - just one commodity with ten or twenty rows ought to do it.

 

[tjkramer]

MrExcelForum Correlation Multi Help.xlsx
	A	B	C	D	E	F	G
1	Dates	Day	Month	Quarter	Year	Spot Peak PJM	Spot Peak NY-J
2	1/1/2010	1	1	1	2010	$45.13	$70.78
3	1/2/2010	2	1	1	2010	$45.13	$70.78
4	1/3/2010	3	1	1	2010	$45.13	$70.78
5	1/4/2010	4	1	1	2010	$102.46	$100.19
6	1/5/2010	5	1	1	2010	$102.94	$106.18
7	1/6/2010	6	1	1	2010	$80.31	$123.06
8	1/7/2010	7	1	1	2010	$87.66	$106.67
9	1/8/2010	8	1	1	2010	$80.09	$98.27
10	1/9/2010	9	1	1	2010	$80.09	$98.27
11	1/10/2010	10	1	1	2010	$80.09	$98.27
12	1/11/2010	11	1	1	2010	$85.14	$99.72
13	1/12/2010	12	1	1	2010	$67.67	$101.51
14	1/13/2010	13	1	1	2010	$53.07	$78.08
15	1/14/2010	14	1	1	2010	$48.46	$63.04
16	1/15/2010	15	1	1	2010	$46.68	$55.09
17	1/16/2010	16	1	1	2010	$46.68	$55.09
18	1/17/2010	17	1	1	2010	$46.68	$55.09
19	1/18/2010	18	1	1	2010	$52.31	$59.16
20	1/19/2010	19	1	1	2010	$46.81	$68.85
21	1/20/2010	20	1	1	2010	$50.15	$71.30
22	1/21/2010	21	1	1	2010	$44.50	$56.12
23	1/22/2010	22	1	1	2010	$46.43	$55.16
24	1/23/2010	23	1	1	2010	$46.43	$55.16
25	1/24/2010	24	1	1	2010	$46.43	$55.16
26	1/25/2010	25	1	1	2010	$42.96	$53.78
27	1/26/2010	26	1	1	2010	$48.61	$56.57
28	1/27/2010	27	1	1	2010	$50.01	$57.14
29	1/28/2010	28	1	1	2010	$47.53	$57.33
30	1/29/2010	29	1	1	2010	$64.84	$71.39
31	1/30/2010	30	1	1	2010	$64.84	$71.39
32	1/31/2010	31	1	1	2010	$64.84	$71.39
33	2/1/2010	1	2	1	2010	$59.65	$72.59
34	2/2/2010	2	2	1	2010	$51.41	$64.42
35	2/3/2010	3	2	1	2010	$42.82	$59.66
36	2/4/2010	4	2	1	2010	$47.00	$59.42
37	2/5/2010	5	2	1	2010	$55.38	$62.94
38	2/6/2010	6	2	1	2010	$55.38	$62.94
39	2/7/2010	7	2	1	2010	$55.38	$62.94
40	2/8/2010	8	2	1	2010	$68.19	$90.42
41	2/9/2010	9	2	1	2010	$60.12	$80.50
42	2/10/2010	10	2	1	2010	$60.44	$77.29
43	2/11/2010	11	2	1	2010	$56.45	$74.21
44	2/12/2010	12	2	1	2010	$52.65	$67.37
45	2/13/2010	13	2	1	2010	$52.65	$67.37
46	2/14/2010	14	2	1	2010	$52.65	$67.37
47	2/15/2010	15	2	1	2010	$49.63	$60.19
48	2/16/2010	16	2	1	2010	$61.01	$62.57
49	2/17/2010	17	2	1	2010	$47.40	$58.49
50	2/18/2010	18	2	1	2010	$45.65	$54.68
51	2/19/2010	19	2	1	2010	$51.55	$52.32
52	2/20/2010	20	2	1	2010	$51.55	$52.32
53	2/21/2010	21	2	1	2010	$51.55	$52.32
54	2/22/2010	22	2	1	2010	$46.49	$63.21
55	2/23/2010	23	2	1	2010	$42.92	$59.78
56	2/24/2010	24	2	1	2010	$47.37	$48.46
57	2/25/2010	25	2	1	2010	$50.42	$57.23
58	2/26/2010	26	2	1	2010	$47.85	$49.53
59	2/27/2010	27	2	1	2010	$47.85	$49.53
60	2/28/2010	28	2	1	2010	$47.85	$49.53
61	3/1/2010	1	3	1	2010	$45.76	$48.05
62	3/2/2010	2	3	1	2010	$46.20	$50.21
63	3/3/2010	3	3	1	2010	$47.73	$51.56
64	3/4/2010	4	3	1	2010	$46.28	$47.61
65	3/5/2010	5	3	1	2010	$42.50	$49.96
66	3/6/2010	6	3	1	2010	$42.50	$49.96
67	3/7/2010	7	3	1	2010	$42.50	$49.96
68	3/8/2010	8	3	1	2010	$47.31	$49.91
69	3/9/2010	9	3	1	2010	$48.29	$47.25
70	3/10/2010	10	3	1	2010	$37.22	$46.68
71	3/11/2010	11	3	1	2010	$35.93	$45.93
72	3/12/2010	12	3	1	2010	$37.03	$45.99
73	3/13/2010	13	3	1	2010	$37.03	$45.99
74	3/14/2010	14	3	1	2010	$37.03	$45.99
75	3/15/2010	15	3	1	2010	$44.13	$50.79
76	3/16/2010	16	3	1	2010	$42.06	$49.40
77	3/17/2010	17	3	1	2010	$38.06	$45.30
78	3/18/2010	18	3	1	2010	$40.03	$52.00
79	3/19/2010	19	3	1	2010	$38.10	$47.58
80	3/20/2010	20	3	1	2010	$38.10	$47.58
81	3/21/2010	21	3	1	2010	$38.10	$47.58
82	3/22/2010	22	3	1	2010	$44.90	$53.19
83	3/23/2010	23	3	1	2010	$40.34	$51.64
84	3/24/2010	24	3	1	2010	$41.07	$55.92
85	3/25/2010	25	3	1	2010	$40.34	$42.88
86	3/26/2010	26	3	1	2010	$45.51	$47.84
87	3/27/2010	27	3	1	2010	$45.51	$47.84
88	3/28/2010	28	3	1	2010	$45.51	$47.84
89	3/29/2010	29	3	1	2010	$40.36	$49.11
90	3/30/2010	30	3	1	2010	$41.25	$46.24
91	3/31/2010	31	3	1	2010	$38.30	$42.62
92	4/1/2010	1	4	2	2010	$38.01	$47.31
93	4/2/2010	2	4	2	2010	$36.69	$46.47
94	4/3/2010	3	4	2	2010	$36.69	$46.47
95	4/4/2010	4	4	2	2010	$36.69	$46.47
96	4/5/2010	5	4	2	2010	$44.27	$45.64
97	4/6/2010	6	4	2	2010	$58.56	$46.99
98	4/7/2010	7	4	2	2010	$64.18	$57.03
99	4/8/2010	8	4	2	2010	$52.89	$58.28
100	4/9/2010	9	4	2	2010	$40.11	$44.30
101	4/10/2010	10	4	2	2010	$40.11	$44.30
102	4/11/2010	11	4	2	2010	$40.11	$44.30
103	4/12/2010	12	4	2	2010	$42.16	$44.70
104	4/13/2010	13	4	2	2010	$44.36	$46.92
105	4/14/2010	14	4	2	2010	$43.11	$50.91
106	4/15/2010	15	4	2	2010	$45.79	$49.98
107	4/16/2010	16	4	2	2010	$43.12	$46.63
108	4/17/2010	17	4	2	2010	$43.12	$46.63
109	4/18/2010	18	4	2	2010	$43.12	$46.63
110	4/19/2010	19	4	2	2010	$44.41	$52.19
111	4/20/2010	20	4	2	2010	$42.34	$55.30
112	4/21/2010	21	4	2	2010	$41.22	$59.26
113	4/22/2010	22	4	2	2010	$43.62	$57.86
114	4/23/2010	23	4	2	2010	$41.51	$56.79
115	4/24/2010	24	4	2	2010	$41.51	$56.79
116	4/25/2010	25	4	2	2010	$41.51	$56.79
117	4/26/2010	26	4	2	2010	$44.47	$52.04
118	4/27/2010	27	4	2	2010	$42.09	$53.02
119	4/28/2010	28	4	2	2010	$41.11	$55.54
120	4/29/2010	29	4	2	2010	$39.90	$56.39
121	4/30/2010	30	4	2	2010	$45.42	$60.62
122	5/1/2010	1	5	2	2010	$45.42	$60.62
123	5/2/2010	2	5	2	2010	$45.42	$60.62
124	5/3/2010	3	5	2	2010	$59.26	$61.76
125	5/4/2010	4	5	2	2010	$62.41	$57.84
126	5/5/2010	5	5	2	2010	$52.76	$61.95
127	5/6/2010	6	5	2	2010	$48.81	$70.23
128	5/7/2010	7	5	2	2010	$42.46	$58.59
129	5/8/2010	8	5	2	2010	$42.46	$58.59
130	5/9/2010	9	5	2	2010	$42.46	$58.59
131	5/10/2010	10	5	2	2010	$39.34	$51.51
132	5/11/2010	11	5	2	2010	$39.21	$53.38
133	5/12/2010	12	5	2	2010	$44.72	$54.63
134	5/13/2010	13	5	2	2010	$43.45	$55.39
135	5/14/2010	14	5	2	2010	$52.39	$56.16
136	5/15/2010	15	5	2	2010	$52.39	$56.16
137	5/16/2010	16	5	2	2010	$52.39	$56.16
138	5/17/2010	17	5	2	2010	$45.61	$57.18
139	5/18/2010	18	5	2	2010	$43.88	$55.22
140	5/19/2010	19	5	2	2010	$43.88	$52.22
141	5/20/2010	20	5	2	2010	$50.25	$57.84
142	5/21/2010	21	5	2	2010	$51.45	$60.83
143	5/22/2010	22	5	2	2010	$51.45	$60.83
144	5/23/2010	23	5	2	2010	$51.45	$60.83
145	5/24/2010	24	5	2	2010	$48.06	$52.58
146	5/25/2010	25	5	2	2010	$54.37	$59.40
147	5/26/2010	26	5	2	2010	$69.58	$78.97
148	5/27/2010	27	5	2	2010	$65.07	$73.19
149	5/28/2010	28	5	2	2010	$40.08	$51.00
150	5/29/2010	29	5	2	2010	$40.08	$51.00
151	5/30/2010	30	5	2	2010	$40.08	$51.00
152	5/31/2010	31	5	2	2010	$40.08	$51.00
153	6/1/2010	1	6	2	2010	$68.17	$70.76
154	6/2/2010	2	6	2	2010	$60.55	$58.63
155	6/3/2010	3	6	2	2010	$57.80	$68.54
156	6/4/2010	4	6	2	2010	$57.56	$63.30
157	6/5/2010	5	6	2	2010	$57.56	$63.30
158	6/6/2010	6	6	2	2010	$57.56	$63.30
159	6/7/2010	7	6	2	2010	$48.62	$58.77
160	6/8/2010	8	6	2	2010	$44.95	$55.92
161	6/9/2010	9	6	2	2010	$43.20	$48.99
162	6/10/2010	10	6	2	2010	$50.95	$52.88
163	6/11/2010	11	6	2	2010	$53.32	$53.53
164	6/12/2010	12	6	2	2010	$53.32	$53.53
165	6/13/2010	13	6	2	2010	$53.32	$53.53
166	6/14/2010	14	6	2	2010	$61.03	$71.04
167	6/15/2010	15	6	2	2010	$50.44	$54.56
168	6/16/2010	16	6	2	2010	$54.39	$56.55
169	6/17/2010	17	6	2	2010	$58.56	$58.96
170	6/18/2010	18	6	2	2010	$59.39	$67.16
171	6/19/2010	19	6	2	2010	$59.39	$67.16
172	6/20/2010	20	6	2	2010	$59.39	$67.16
173	6/21/2010	21	6	2	2010	$64.39	$75.06
174	6/22/2010	22	6	2	2010	$70.06	$72.23
175	6/23/2010	23	6	2	2010	$79.18	$91.40
176	6/24/2010	24	6	2	2010	$83.41	$116.04
177	6/25/2010	25	6	2	2010	$63.62	$68.71
178	6/26/2010	26	6	2	2010	$63.62	$68.71
179	6/27/2010	27	6	2	2010	$63.62	$68.71
180	6/28/2010	28	6	2	2010	$87.87	$119.37
181	6/29/2010	29	6	2	2010	$64.79	$81.72
182	6/30/2010	30	6	2	2010	$43.91	$60.47
183	7/1/2010	1	7	3	2010	$41.77	$54.72
184	7/2/2010	2	7	3	2010	$42.51	$51.13
185	7/3/2010	3	7	3	2010	$42.51	$51.13
186	7/4/2010	4	7	3	2010	$42.51	$51.13
187	7/5/2010	5	7	3	2010	$42.51	$51.13
188	7/6/2010	6	7	3	2010	$135.93	$122.12
189	7/7/2010	7	7	3	2010	$151.10	$141.42
190	7/8/2010	8	7	3	2010	$101.30	$129.09
191	7/9/2010	9	7	3	2010	$71.47	$114.04
192	7/10/2010	10	7	3	2010	$71.47	$114.04
193	7/11/2010	11	7	3	2010	$71.47	$114.04
194	7/12/2010	12	7	3	2010	$75.86	$82.81
195	7/13/2010	13	7	3	2010	$61.49	$93.95
196	7/14/2010	14	7	3	2010	$70.86	$91.19
197	7/15/2010	15	7	3	2010	$86.11	$103.21
198	7/16/2010	16	7	3	2010	$85.65	$115.88
199	7/17/2010	17	7	3	2010	$85.65	$115.88
200	7/18/2010	18	7	3	2010	$85.65	$115.88
201	7/19/2010	19	7	3	2010	$86.10	$113.58
202	7/20/2010	20	7	3	2010	$71.86	$100.64
203	7/21/2010	21	7	3	2010	$73.81	$85.57
204	7/22/2010	22	7	3	2010	$79.66	$81.43
205	7/23/2010	23	7	3	2010	$98.60	$99.31
206	7/24/2010	24	7	3	2010	$98.60	$99.31
207	7/25/2010	25	7	3	2010	$98.60	$99.31
208	7/26/2010	26	7	3	2010	$63.48	$76.05
209	7/27/2010	27	7	3	2010	$58.79	$74.01
210	7/28/2010	28	7	3	2010	$78.52	$88.14
211	7/29/2010	29	7	3	2010	$72.10	$90.82
212	7/30/2010	30	7	3	2010	$57.88	$70.08
213	7/31/2010	31	7	3	2010	$57.88	$70.08
214	8/1/2010	1	8	3	2010	$57.88	$70.08
215	8/2/2010	2	8	3	2010	$63.23	$69.69
216	8/3/2010	3	8	3	2010	$71.89	$82.68
217	8/4/2010	4	8	3	2010	$75.41	$103.77
218	8/5/2010	5	8	3	2010	$87.79	$126.30
219	8/6/2010	6	8	3	2010	$62.19	$80.58
220	8/7/2010	7	8	3	2010	$62.19	$80.58
221	8/8/2010	8	8	3	2010	$62.19	$80.58
222	8/9/2010	9	8	3	2010	$72.94	$81.77
223	8/10/2010	10	8	3	2010	$88.46	$102.08
224	8/11/2010	11	8	3	2010	$87.80	$107.87
225	8/12/2010	12	8	3	2010	$74.82	$79.83
226	8/13/2010	13	8	3	2010	$61.54	$70.07
227	8/14/2010	14	8	3	2010	$61.54	$70.07
228	8/15/2010	15	8	3	2010	$61.54	$70.07
229	8/16/2010	16	8	3	2010	$72.76	$77.02
230	8/17/2010	17	8	3	2010	$61.05	$75.83
231	8/18/2010	18	8	3	2010	$51.35	$70.88
232	8/19/2010	19	8	3	2010	$58.03	$66.33
233	8/20/2010	20	8	3	2010	$61.19	$68.35
234	8/21/2010	21	8	3	2010	$61.19	$68.35
235	8/22/2010	22	8	3	2010	$61.19	$68.35
236	8/23/2010	23	8	3	2010	$53.04	$72.04
237	8/24/2010	24	8	3	2010	$42.10	$61.20
238	8/25/2010	25	8	3	2010	$40.51	$56.69
239	8/26/2010	26	8	3	2010	$44.62	$57.94
240	8/27/2010	27	8	3	2010	$40.29	$53.27
241	8/28/2010	28	8	3	2010	$40.29	$53.27
242	8/29/2010	29	8	3	2010	$40.29	$53.27
243	8/30/2010	30	8	3	2010	$71.08	$73.96
244	8/31/2010	31	8	3	2010	$68.02	$81.83
245	9/1/2010	1	9	3	2010	$69.98	$81.79
246	9/2/2010	2	9	3	2010	$55.50	$81.69
247	9/3/2010	3	9	3	2010	$49.85	$61.98
248	9/4/2010	4	9	3	2010	$49.85	$61.98
249	9/5/2010	5	9	3	2010	$49.85	$61.98
250	9/6/2010	6	9	3	2010	$49.85	$61.98
251	9/7/2010	7	9	3	2010	$52.57	$61.19
252	9/8/2010	8	9	3	2010	$42.28	$63.56
253	9/9/2010	9	9	3	2010	$40.24	$53.21
254	9/10/2010	10	9	3	2010	$36.02	$50.92
255	9/11/2010	11	9	3	2010	$36.02	$50.92
256	9/12/2010	12	9	3	2010	$36.02	$50.92
257	9/13/2010	13	9	3	2010	$48.02	$54.65
258	9/14/2010	14	9	3	2010	$48.50	$54.44
259	9/15/2010	15	9	3	2010	$49.84	$53.33
260	9/16/2010	16	9	3	2010	$48.10	$58.35
261	9/17/2010	17	9	3	2010	$49.19	$55.51
262	9/18/2010	18	9	3	2010	$49.19	$55.51
263	9/19/2010	19	9	3	2010	$49.19	$55.51
264	9/20/2010	20	9	3	2010	$44.71	$55.53
265	9/21/2010	21	9	3	2010	$45.54	$52.07
266	9/22/2010	22	9	3	2010	$53.84	$65.00
267	9/23/2010	23	9	3	2010	$65.38	$68.12
268	9/24/2010	24	9	3	2010	$74.03	$66.91
269	9/25/2010	25	9	3	2010	$74.03	$66.91
270	9/26/2010	26	9	3	2010	$74.03	$66.91
271	9/27/2010	27	9	3	2010	$49.97	$53.17
272	9/28/2010	28	9	3	2010	$53.28	$60.50
273	9/29/2010	29	9	3	2010	$51.55	$58.17
274	9/30/2010	30	9	3	2010	$48.81	$61.77
275	10/1/2010	1	10	4	2010	$41.81	$53.76
276	10/2/2010	2	10	4	2010	$41.81	$53.76
277	10/3/2010	3	10	4	2010	$41.81	$53.76
278	10/4/2010	4	10	4	2010	$47.02	$48.45
279	10/5/2010	5	10	4	2010	$37.65	$46.81
280	10/6/2010	6	10	4	2010	$37.89	$45.83
281	10/7/2010	7	10	4	2010	$39.12	$44.77
282	10/8/2010	8	10	4	2010	$38.67	$44.10
283	10/9/2010	9	10	4	2010	$38.67	$44.10
284	10/10/2010	10	10	4	2010	$38.67	$44.10
285	10/11/2010	11	10	4	2010	$37.88	$43.71
286	10/12/2010	12	10	4	2010	$41.19	$43.81
287	10/13/2010	13	10	4	2010	$38.85	$43.00
288	10/14/2010	14	10	4	2010	$40.84	$46.40
289	10/15/2010	15	10	4	2010	$36.49	$44.78
290	10/16/2010	16	10	4	2010	$36.49	$44.78
291	10/17/2010	17	10	4	2010	$36.49	$44.78
292	10/18/2010	18	10	4	2010	$43.58	$48.04
293	10/19/2010	19	10	4	2010	$43.52	$48.07
294	10/20/2010	20	10	4	2010	$40.81	$47.42
295	10/21/2010	21	10	4	2010	$42.23	$49.03
296	10/22/2010	22	10	4	2010	$38.63	$48.30
297	10/23/2010	23	10	4	2010	$38.63	$48.30
298	10/24/2010	24	10	4	2010	$38.63	$48.30
299	10/25/2010	25	10	4	2010	$41.46	$47.32
300	10/26/2010	26	10	4	2010	$46.97	$46.25
301	10/27/2010	27	10	4	2010	$43.70	$50.01
302	10/28/2010	28	10	4	2010	$44.64	$44.80
303	10/29/2010	29	10	4	2010	$40.94	$41.79
304	10/30/2010	30	10	4	2010	$40.94	$41.79
305	10/31/2010	31	10	4	2010	$40.94	$41.79
306	11/1/2010	1	11	4	2010	$45.82	$46.74
307	11/2/2010	2	11	4	2010	$43.78	$45.59
308	11/3/2010	3	11	4	2010	$42.63	$48.09
309	11/4/2010	4	11	4	2010	$44.11	$50.20
310	11/5/2010	5	11	4	2010	$38.64	$48.91
311	11/6/2010	6	11	4	2010	$38.64	$48.91
312	11/7/2010	7	11	4	2010	$38.64	$48.91
313	11/8/2010	8	11	4	2010	$46.43	$47.94
314	11/9/2010	9	11	4	2010	$42.84	$50.66
315	11/10/2010	10	11	4	2010	$39.35	$52.20
316	11/11/2010	11	11	4	2010	$40.53	$54.39
317	11/12/2010	12	11	4	2010	$39.51	$54.18
318	11/13/2010	13	11	4	2010	$39.51	$54.18
319	11/14/2010	14	11	4	2010	$39.51	$54.18
320	11/15/2010	15	11	4	2010	$42.39	$53.82
321	11/16/2010	16	11	4	2010	$42.32	$54.03
322	11/17/2010	17	11	4	2010	$43.29	$53.56
323	11/18/2010	18	11	4	2010	$44.30	$50.97
324	11/19/2010	19	11	4	2010	$47.68	$52.72
325	11/20/2010	20	11	4	2010	$47.68	$52.72
326	11/21/2010	21	11	4	2010	$47.68	$52.72
327	11/22/2010	22	11	4	2010	$42.01	$52.57
328	11/23/2010	23	11	4	2010	$38.45	$51.53
329	11/24/2010	24	11	4	2010	$40.47	$51.11
330	11/25/2010	25	11	4	2010	$40.47	$51.11
331	11/26/2010	26	11	4	2010	$37.03	$44.95
332	11/27/2010	27	11	4	2010	$37.03	$44.95
333	11/28/2010	28	11	4	2010	$37.03	$44.95
334	11/29/2010	29	11	4	2010	$41.11	$52.47
335	11/30/2010	30	11	4	2010	$39.54	$51.94
336	12/1/2010	1	12	4	2010	$41.24	$54.40
337	12/2/2010	2	12	4	2010	$49.05	$56.97
338	12/3/2010	3	12	4	2010	$42.91	$57.75
339	12/4/2010	4	12	4	2010	$42.91	$57.75
340	12/5/2010	5	12	4	2010	$42.91	$57.75
341	12/6/2010	6	12	4	2010	$50.05	$61.72
342	12/7/2010	7	12	4	2010	$53.38	$62.59
343	12/8/2010	8	12	4	2010	$65.04	$62.98
344	12/9/2010	9	12	4	2010	$75.56	$74.26
345	12/10/2010	10	12	4	2010	$51.52	$81.48
346	12/11/2010	11	12	4	2010	$51.52	$81.48
347	12/12/2010	12	12	4	2010	$51.52	$81.48
348	12/13/2010	13	12	4	2010	$73.91	$80.62
349	12/14/2010	14	12	4	2010	$95.41	$102.16
350	12/15/2010	15	12	4	2010	$117.22	$142.44
351	12/16/2010	16	12	4	2010	$101.53	$130.12
352	12/17/2010	17	12	4	2010	$75.44	$105.34
353	12/18/2010	18	12	4	2010	$75.44	$105.34
354	12/19/2010	19	12	4	2010	$75.44	$105.34
355	12/20/2010	20	12	4	2010	$69.19	$120.43
356	12/21/2010	21	12	4	2010	$71.90	$120.36
357	12/22/2010	22	12	4	2010	$58.11	$109.37
358	12/23/2010	23	12	4	2010	$56.58	$76.45
359	12/24/2010	24	12	4	2010	$46.34	$57.44
360	12/25/2010	25	12	4	2010	$46.34	$57.44
361	12/26/2010	26	12	4	2010	$46.34	$57.44
362	12/27/2010	27	12	4	2010	$82.54	$92.00
363	12/28/2010	28	12	4	2010	$66.25	$99.42
364	12/29/2010	29	12	4	2010	$48.05	$98.86
365	12/30/2010	30	12	4	2010	$43.98	$72.55
366	12/31/2010	31	12	4	2010	$40.86	$51.06
Data

 

[tjkramer]

Trying to get it to feed this table please...

MrExcelForum Correlation Multi Help.xlsx
	L	M	N	O	P	Q
2			Q1	Q2	Q3	Q4
3			Spot Peak NY-J	Spot Peak NY-J	Spot Peak NY-J	Spot Peak NY-J
4	Q1	Spot Peak PJM
5	Q2	Spot Peak PJM
6	Q3	Spot Peak PJM
7	Q4	Spot Peak PJM
Data