Forum Discussion
Gregory Guthrie
Jun 30, 2023Tin Contributor
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...
Harun24HR
Aug 19, 2026Silver Contributor
GROUPBY() function may work for you.
=GROUPBY(EOMONTH(+A1:A35,0),B1:B35,AVERAGE,,0)