Forecasting earlier numbers

Question

Dear Excel Community I have figures from Apr to Oct and i want to get approximate figures of Jan to Mar how can i do that, Need help and logic as data is increasing&nbsp;Thanks for your quick response&nbsp;&nbsp;&nbsp;Account/Month&nbsp;&nbsp;Jan&nbsp;&nbsp;Feb&nbsp;&nbsp;Mar&nbsp;&nbsp;Apr&nbsp;&nbsp;May&nbsp;&nbsp;Jun&nbsp;&nbsp;Jul&nbsp;&nbsp;Aug&nbsp;&nbsp;Sep&nbsp;&nbsp;Oct&nbsp;&nbsp;Traveling Expense&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29,604&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 37,284&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33,581&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35,504&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44,104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44,464

lorenzo kim · Answer

try:=AVERAGE(F2:K2)for each cell B,C,D,Ehope this helps..&nbsp;or maybe=RANDBETWEEN(F2,M2)

sergeibaklan · Answer

Another option is to use TREND function, but it requires numeric X-axis

&nbsp;

muzahir hussain · Answer

Thanks Dear,&nbsp;But Forecast Function is giving more realistic values&nbsp;

Forum Discussion

Forecasting earlier numbers

3 Replies

Account/Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct
Traveling Expense					29,604	37,284	33,581	35,504	44,104	44,464