|I have multiple (between two and six usually) temperature values for single dates. I need (1) a way to average the values for each date; (2) to put the averaged values in a column next to the appropriate date so they are in the same row and there are no duplicates. |
It is a large quantity of data that perhaps requires some kind of batch code that I unfortunately do not know how to write. Is this possible using Excel 2010? Thank you!