Omit column from Trend formula

[tsolis13]

Hi!

I am using a TREND formula for the first time to predict oil price and sales through the end of 2018 (cells using formula in red). I believe I managed to get the TREND formula to work for column B (Price), but do not think it is populating correctly for column C (Net Vol). I will need to use TREND on column D (Gross Sales) as well. I am assuming the issue lies within the fact that the formula picks up all columns to the left of column A when populating column C and D.

Is there anyway I can filter for just column A (Month) when finalizing the TREND formula for column C and D? Hopefully I'm making sense. Thank you!

Month	Price	Net Vol	Gross Sales
June17	44.11	2,640.71	116,474.97
July17	46.47	2,516.82	116,955.79
Aug17	48.23	2,021.35	97,497.11
Sep17	50.42	2,265.90	114,235.94
Oct17	53.98	2,034.09	109,792.86
Nov17	60.13	1,826.73	109,838.36
Dec17	61.70	1,864.81	115,061.01
Jan18	67.00	1,825.89	122,326.94
Feb18	64.74	1,555.79	100,716.47
Mar18	63.55	1,701.69	108,140.59
Apr18	68.00	474.38	32,258.77
May18	72.22	988.39	?
Jun18	74.72	927.54	?

<tbody>
</tbody>

 

[DRSteele]

I'm not quite sure what you're getting at with the filter commentary. But I've got the trend formula built here with an expanding range. Copy B13 across and down.

It is never a good idea in Excel to have dates listed as they are in your ColA; it is best to make them be Excel Date Serial Numbers so that functions like TREND can work properly. You can always apply a NumberFormat to display them however you like.

Book1
	A	B	C	D
1	Month	Price	Net Vol	Gross Sales
2	6/01/17	44.11	2,640.71	116,474.97
3	7/01/17	46.47	2,516.82	116,955.79
4	8/01/17	48.23	2,021.35	97,497.11
5	9/01/17	50.42	2,265.90	114,235.94
6	10/01/17	53.98	2,034.09	109,792.86
7	11/01/17	60.13	1,826.73	109,838.36
8	12/01/17	61.70	1,864.81	115,061.01
9	1/01/18	67.00	1,825.89	122,326.94
10	2/01/18	64.74	1,555.79	100,716.47
11	3/01/18	63.55	1,701.69	108,140.59
12	4/01/18	68.00	474.38	32,258.77
13	5/01/18	72.22	988.39	80,974.50
14	6/01/18	74.80	835.39	77,053.64
Sheet75

Cell Formulas
Range	Formula
B13	=TREND(B$2:B12,$A$2:$A12,$A13)