Hi,

column A months
column B values, but for some months the data are missing

how to create in column C a table of values assigning values to the missing
months, based on a linear equation, connecting the last previous value and
the first next value

so how to create column C?

e.g.

A B C
Feb-97 27 27
Mar-97 25
Apr-97 23 23
May-97 26 26
Jun-97 27
Jul-97 28 28
Aug-97 27.8
Sep-97 27.6
Oct-97 27.4
Nov-97 27.2
Dec-97 27 27


Thanks!

tom