Thread: Array & Trend
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Array & Trend

I believe this will do it:
=TREND(C3:E3,C2:E2,B2)

I would recommend arranging your data from smallest to largest; this seems
more intuitive.



Regards,
Ryan---


--
RyGuy


"Gator" wrote:

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