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
Thanks for your quick response
try:=AVERAGE(F2:K2)for each cell B,C,D,Ehope this helps..
Another option is to use TREND function, but it requires numeric X-axis
But Forecast Function is giving more realistic values