Forum Discussion
Forecasting earlier numbers
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,E
hope this helps..
or maybe
=RANDBETWEEN(F2,M2)