Array & Trend

G

Gator

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.
 
R

ryguy7272

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---
 
Top