Thread: Array & Trend
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Array & Trend

=TREND(B2:D2,B1:D1,A1)

--


Regards,


Peo Sjoblom


"Gator" wrote in message
...
How do I set up the trend function for the following?

A B C D
1 2008 2007 2006 2005
2 ??? 12 10 9

where the ??? is what I want the trend to be.
--
Gator