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!
<tbody>
</tbody>
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>
Last edited: