Is the data linear? Look at FORECAST and TREND.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"cf" wrote in message
...
want to determine a value for a period of years that i do not have data