Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
missing data from table | Excel Discussion (Misc queries) | |||
missing data from table | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |