Hi,

I need to calculate a projected figure, based on previous months...

i.e;

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
123 345 677 899 1002 1400 ??? ??? ??? ???
??? ???

The number is cumulative from month to month....

I have previously used the average of the difference between the months, but
this is not that great to use...

Are there any functions in excel that can do this for me?

Many thanks,


Mark.