Forum Discussion
linear interpolation of sparse data
I have several lists of data, each sampled at different varying intervals. I want to merge them into an average set of readings, but since they are each missing data and have readings at different ti...
3 years later. . .
If you're still on these forums, you're welcome to use GroupbyDateλ. It's included in the attached workbook. Enjoy!
=GroupbyDateλ(Date,Reading,"Month",AVERAGE)