I am a supporter ofSt. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation toSt. Joseph's, please.
Information onSt. Joseph's
You can use linear interpolation to fill gaps in a table of numbers with worksheet functions:
I deem the approach with helper columns superior because it’s using less runtime by far. A FastExcel © analysis revealed: