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
|