Hello,
I am trying to forecast the price by city from a data set. Here is an example of what it looks like:
<tbody>
</tbody>
What I want to do is use this historical data to identify what the price will be (by city) in May! That means that I only want to use historical data from May (not ALL of the months). I know there is a FORECAST formula, but I don't know if that will work with the way my data sheet is organized. Any ideas?
Thank you! I appreciate your help.
I am trying to forecast the price by city from a data set. Here is an example of what it looks like:
CITY | 6/17/2011 | 12/2/2011 | 2/26/2012 | 4/30/2012 | 8/2/2012 | 11/21/2012 | 1/11/2013 | 2/14/2013 | 5/3/2013 | 7/30/2013 | 11/8/2013 | 1/9/2014 | 2/11/2014 |
AIKEN, SC | $ - | $ - | $ - | $ - | $ - | $ - | $ 14.74 | $ - | $ - | $ - | $ - | $ - | $ - |
AKRON, OH | $ - | $ - | $ - | $ - | $16.73 | $ - | $ - | $ - | $ - | $ 12.99 | $ - | $ - | $ - |
ALBUQUERQUE, NM | $ - | $ - | $ - | $ - | $ - | $ - | $ 15.08 | $ - | $ - | $ - | $ - | $ - | $ - |
<tbody>
</tbody>
What I want to do is use this historical data to identify what the price will be (by city) in May! That means that I only want to use historical data from May (not ALL of the months). I know there is a FORECAST formula, but I don't know if that will work with the way my data sheet is organized. Any ideas?
Thank you! I appreciate your help.