Return Day number of max values, and max value, for a list of years with daily data

Hi there,

I'm hoping to fill in the last two column of this worksheet with max value, and day number when it occurs.

Any thoughts.


Year Date Day Number Meters
1973 01/01/1973 1 668.813496 Year Day Number Max Value
1973 02/01/1973 2 668.786064 1973
1973 03/01/1973 3 668.755584 1974
1973 04/01/1973 4 668.67024 1975
1973 05/01/1973 5 668.636712 1976
1973 06/01/1973 6 668.536128 1977
1973 07/01/1973 7 668.496504 1978
1973 08/01/1973 8 668.453832 1979
1973 09/01/1973 9 668.41116 1980
1973 10/01/1973 10 668.368488 1981
1973 11/01/1973 11 668.280096 1982
1973 12/01/1973 12 668.185608 1983
1973 13/01/1973 13 668.149032 1984
1973 14/01/1973 14 668.002728 1985
1973 15/01/1973 15 667.972248 1986
1973 16/01/1973 16 667.972248 1987
1973 17/01/1973 17 667.914336 1988
1973 18/01/1973 18 667.926528 1989
1973 19/01/1973 19 667.841184 1990
1973 20/01/1973 20 667.792416 1991

Capture.PNG

I hoping this will attach a screenshot we'll see

Day number is my third column.

Exactly, I'm looking for the max of the meters columns for each year.

Thanks for helping!!