I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Fill Gaps

You can use linear interpolation to fill gaps in a table of numbers with worksheet functions:

20091010_Interpolate_Fill_Gaps

I deem the approach with helper columns superior because it’s using less runtime by far. A FastExcel © analysis revealed:

20091010_Interpolate_Fill_Gaps_FastExcel
Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download