Enter the data for london in range A2:L2. In range A1:L1 enter 1 to 12,
and then drag forward till 18. In cell M2 enter the formula:
=TREND($A$2:$L$2,$A$1:$L$1,M1)
and drag to copy to your right.

This example simply shows how TREND works, and it does not guarantee
the accuracy of the method for your forecasting purpose.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381525