Greetings ExcelForum community,
I have tens of thousands of datapoints that I have to average and doing it by hand is out of the question.
Basically, I have a long set of "distances" and data taken from each of those distances. I need to average the data within a certain distance interval. For instance, I need to average the temperature taken between 1ft and 9ft. I've made a dummy-sheet so feel free to check that out. Any help would be so greatly appreciated! I've been working on this for weeks so I believe it's time I reach out for help. Please let me know if there are any clarifications you need.
Thanks!
Bookmarks