I've run into a situation I can't seem to solve, so hopefully someone on here can figure it out.
I'm trying to "predict" what the next value would be, using previous years data.
I've got four colums, representing 4 years. A-D Then A2-A13, B2-B13 etc. Has the values for the months in that year.
I.e.
2000..2001..2002..2003..2004
13......15.......13.....11
15......19.......21.....5
11......22........15....13
Now I need for column E to have the predicted value for that year. Is there a simple way, or simple formula to do this? I tried using the FORECAST formula, but couldn't get it to work.
So do any of you know a way to do this?
Thanks;
JohnK
I'm trying to "predict" what the next value would be, using previous years data.
I've got four colums, representing 4 years. A-D Then A2-A13, B2-B13 etc. Has the values for the months in that year.
I.e.
2000..2001..2002..2003..2004
13......15.......13.....11
15......19.......21.....5
11......22........15....13
Now I need for column E to have the predicted value for that year. Is there a simple way, or simple formula to do this? I tried using the FORECAST formula, but couldn't get it to work.
So do any of you know a way to do this?
Thanks;
JohnK