Linest ARRRGHHHH

[Guest]

I can't seem to master this, here goes:
I got years listed in 1 row as follows:
2005 2006 2007 2008 2009
0% X X X 10%
If my goal is a 10% market share by 2009, how the heck do I write a formula
that will return the middle values for years 2006-2008 given a beggining
(O.001%) and a goal (10% by year 2009)?
Furthermore I can't seem master my "Array" since my "Y" values are
discontinuos....ARRGH (exact formula appreciated)
Ken

 

[John Vinson]

I can't seem to master this, here goes:
I got years listed in 1 row as follows:
2005 2006 2007 2008 2009
0% X X X 10%
If my goal is a 10% market share by 2009, how the heck do I write a formula
that will return the middle values for years 2006-2008 given a beggining
(O.001%) and a goal (10% by year 2009)?
Furthermore I can't seem master my "Array" since my "Y" values are
discontinuos....ARRGH (exact formula appreciated)
Ken

Ken, are you trying to do this in Microsoft Access (in which case it's
going to require some serious VBA coding) or - probably more
appropriately - in Excel? If the latter, I'd suggest posting your
question in an Excel newsgroup.