Climate data w/multiple stations reporting data from the same date->consolidating rows?

Hello all!

---

*Please see the example file here: climate data.xlsx

---

I am doing research using climate data with the following parameters arranged as rows left-to-right:

• Date (mm/yyyy)
• StationID
• Extreme MinT
• Mean MinT
• Average MeanT
• Mean MaxT
• Extreme MaxT

Dates repeat as there are multiple monitoring stations coming online for a couple of years then falling offline. Eventually the original station no longer reports data at all in which case I must switch primary stations.

Some stations do not report full data and are thus deleted altogether. However, the problem arises when there are multiple monitoring stations reporting slight non-anomalous variations in data. For these rows, there are duplicate dates.

For example:

A	B	C	D	E	F	G
DATE	STATION	Extreme MinT	Mean MinT	Average MeanT	Mean MaxT	Extreme MaxT
1/1939	Station1	-13.3	-4.3	-.1	4.1	13.9
1/1939	Station2	-12.8	-3.3	.3	3.9	14.4

I wish to format the data as such:

=average(C:G)

but only for each set of duplicated months.

In short, for the monitoring stations that have reported data for the same month, I wish to take an average of that data and use that to consolidate the rows so there are no duplicate months. The StationID column values in each cell can be erased as well during this process if need be.


Thanks in advance for any help or direction I may be given!
Andrew.

P.S. I am familiar with VBA and can use it if needed to solve this issue.