View Single Post
  #1   Report Post  
Rocket Rod
 
Posts: n/a
Default interpolate missing data between points

Is there a way to automatically interpolate missing data between data points
in a spreadsheet
eg there might be a list of sequentail dates and a value against each one
but there might be 4 values missing.
By selecting the cells before and after teh missing 4, and choose a funtion
of interpolate, it automatically determines theer are 4 missing, theerfore
divides teh difference by 5 and adds that to each of the cells in turn -
filling in teh blanks.

Perhaps could be enhanced with options of moving average to calculate teh
next point