Formula needed to find highest total for a given month over the years

[LRATOZ]

Hi,
I am still working on a dashboard for my weather data sheet.
I have rainfall data for each month for many years.
I would like to see in the dashboard the highest value for rainfall for each month and in which year it happened.
Something like this (Fictitious data):

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct
159	96	49	74	130	82	219	65	88	74
2020	2020	2014	2019	2015	2018	2018	2017	2019	2016

I made up a mock spreadsheet with some fictitious data. I had to limit the amount of cells as L2BB only allows for 300 cells maximum. But I hope you will get the gist to see what I mean.
I have listed 5 days of the first three months over three years to limit the amount of data. In real life I got data 365(6) days for each year and it's all in two columns: Dates and Rain gauge readings.
So, the function I'm after will need to calculate the total for each month, then compare the totals for that particular month over the years and then list the sum result for that month and show the year when it happened.
I hope this will make sense as it is not easy for me to put it in proper English (English is not my first language), sorry).
Here's a copy of that code:

2021-06-02 Weather test sheet.xlsx
	A	B	C	D	E	F	G	H
2	The highest total amount of rainfall for:					Jan	Feb	Mar
3	The greatest total for the month					Value	Value	Value
4	Happened in this year					Year	Year	Year
5
6	Expected results					Jan	Feb	Mar
7						42	39	73
8						2019	2020	2018
9	1/01/2018	2
10	2/01/2018	4
11	3/01/2018	8
12	4/01/2018	3
13	5/01/2018	2	19
14	1/02/2018	7
15	2/02/2018	2
16	3/02/2018	5
17	4/02/2018	3
18	5/02/2018	3	20
19	1/03/2018	9
20	2/03/2018	19
21	3/03/2018	24
22	4/03/2018	21
23	5/03/2018	0	73
24	1/01/2019	3
25	2/01/2019	12
26	3/01/2019	9
27	4/01/2019	12
28	5/01/2019	6	42
29	1/02/2019	0
30	2/02/2019	0
31	3/02/2019	5
32	4/02/2019	6
33	5/02/2019	12	23
34	1/03/2019	14
35	2/03/2019	0
36	3/03/2019	23
37	4/03/2019	2
38	5/03/2019	5	44
39	1/01/2020	0
40	2/01/2020	0
41	3/01/2020	2
42	4/01/2020	4
43	5/01/2020	21	27
44	1/02/2020	21
45	2/02/2020	1
46	3/02/2020	14
47	4/02/2020	0
48	5/02/2020	3	39
49	1/03/2020	7
50	2/03/2020	6
51	3/03/2020	5
52	4/03/2020	0
53	5/03/2020	3	21
Sheet2

Cell Formulas
Range	Formula
C13,C53,C48,C43,C38,C33,C28,C23,C18	C13	=SUM(B9:B13)

Named Ranges
Name	Refers To	Cells
Values	=Sheet2!$B$9:$B$53	C13

Obviously I wont' have the totals for each month in my datasheet as I want to keep the datasheet just for pure data and not for formulas or data manipulation. These totals are just there to give you an indication what the total should be.
I hope somebody can assist with this. I've been racking my brains for many days but I just haven't got enough skills to work this out.
I am using Excel 2016.
Many thanks for your help in advance!
Luke

 

[Peter_SSs]

You're welcome. Glad we could help.