Date of Max Value in Date Range

[wobble12]

I have a Table with over 7000 rows of flow data (daily totals), and four columns.

Columns are:
Date
Flow from River
Flow to River
Bio In

I have used maxif to find the max value for a given date range (either quarterly or yearly), but I would like to return the date that the max value occurred.

I need a formula for the date for "Flow to River" max in a given date range please.

Does anyone have a formula to acheive this please?

All data is in date order.

 

[Fluff]

In that case can you simply copy/paste some of your data?

 

[wobble12]

Oh, that works quite well! A selection of the data in question (I have over 7000 rows). So for Q2 2022 as an eg, I need a formula to find the date of the max value for each flow columns. And a formula for the full year for each flow column.
I have maxifs fourmulas to find the actual values, its just I need the dates that they occurred I need.

So Flow to River is 731.5, but I need the date 24/06/22
For Flow from River it is 458.3, so I would need to return the date 08/04/22.

Date	Flow from River (m3)	Flow to River (m3)
18/03/2022	183.30	525.00
19/03/2022	251.50	570.30
20/03/2022	214.20	524.00
21/03/2022	177.80	501.90
22/03/2022	100.80	483.40
23/03/2022	109.60	464.60
24/03/2022	81.30	444.70
25/03/2022	31.40	430.80
26/03/2022	107.10	498.90
27/03/2022	176.80	526.80
28/03/2022	89.20	520.70
29/03/2022	53.00	536.10
30/03/2022	0.00	555.00
31/03/2022	0.00	544.10
01/04/2022	53.90	444.40
02/04/2022	99.90	403.10
03/04/2022	148.00	374.20
04/04/2022	90.30	376.70
05/04/2022	233.10	427.10
06/04/2022	404.60	637.80
07/04/2022	453.80	667.30
08/04/2022	458.30	656.80
09/04/2022	378.70	598.70
10/04/2022	117.10	341.30
11/04/2022	141.60	346.80
12/04/2022	93.90	417.60
13/04/2022	109.30	417.50
14/04/2022	124.10	404.60
15/04/2022	103.90	455.00
16/04/2022	178.80	452.30
17/04/2022	154.40	480.70
18/04/2022	261.00	518.20
19/04/2022	301.00	573.30
20/04/2022	202.80	470.20
21/04/2022	131.00	442.90
22/04/2022	99.40	433.80
23/04/2022	136.90	489.10
24/04/2022	94.70	418.70
25/04/2022	286.00	497.90
26/04/2022	195.20	546.60
27/04/2022	234.10	501.70
28/04/2022	227.30	569.20
29/04/2022	450.70	269.10
30/04/2022	142.40	421.20
01/05/2022	160.10	479.80
02/05/2022	156.10	447.80
03/05/2022	135.50	542.90
04/05/2022	27.10	653.30
05/05/2022	0.10	239.20
06/05/2022	106.60	657.50
07/05/2022	124.30	602.80
08/05/2022	228.10	614.90
09/05/2022	220.60	606.30
10/05/2022	146.20	445.70
11/05/2022	217.70	467.80
12/05/2022	123.40	445.00
13/05/2022	160.90	467.20
14/05/2022	101.60	428.90
15/05/2022	227.50	496.40
16/05/2022	169.00	597.50
17/05/2022	281.40	571.40
18/05/2022	253.80	549.30
19/05/2022	121.20	593.50
20/05/2022	135.00	464.60
21/05/2022	230.60	463.20
22/05/2022	151.30	417.50
23/05/2022	142.70	549.10
24/05/2022	168.00	511.00
25/05/2022	246.40	523.70
26/05/2022	262.70	622.70
27/05/2022	154.00	506.70
28/05/2022	123.30	519.70
29/05/2022	179.90	513.10
30/05/2022	157.40	464.80
31/05/2022	73.40	504.80
01/06/2022	72.80	494.90
02/06/2022	186.10	462.40
03/06/2022	49.90	514.20
04/06/2022	0.00	559.80
05/06/2022	29.30	611.00
06/06/2022	26.80	605.60
07/06/2022	123.80	604.00
08/06/2022	97.50	593.30
09/06/2022	60.30	524.70
10/06/2022	73.20	521.50
11/06/2022	110.60	502.40
12/06/2022	171.10	538.40
13/06/2022	240.10	529.90
14/06/2022	290.40	528.80
15/06/2022	228.50	489.00
16/06/2022	256.70	486.40
17/06/2022	145.90	501.10
18/06/2022	100.70	552.10
19/06/2022	232.50	560.70
20/06/2022	192.60	529.70
21/06/2022	167.90	526.10
22/06/2022	205.20	537.50
23/06/2022	64.90	600.40
24/06/2022	0.00	731.50
25/06/2022	0.10	617.60
26/06/2022	13.60	679.00
27/06/2022	0.00	681.70
28/06/2022	0.10	682.90
29/06/2022	175.00	652.80
30/06/2022	84.50	600.50
01/07/2022	52.20	610.50

 

[Fluff]

Thanks for that.
The formulae you posted work for me

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Date	Flow from River (m3)	Flow to River (m3)
2	18/03/2022	183.3	525			2022	19/03/2022	19/03/2022
3	19/03/2022	251.5	570.3				08/04/2022	24/06/2022
4	20/03/2022	214.2	524
5	21/03/2022	177.8	501.9
6	22/03/2022	100.8	483.4
7	23/03/2022	109.6	464.6
8	24/03/2022	81.3	444.7
9	25/03/2022	31.4	430.8
10	26/03/2022	107.1	498.9
11	27/03/2022	176.8	526.8
12	28/03/2022	89.2	520.7
13	29/03/2022	53	536.1
14	30/03/2022	0	555
15	31/03/2022	0	544.1
16	01/04/2022	53.9	444.4
17	02/04/2022	99.9	403.1
18	03/04/2022	148	374.2
19	04/04/2022	90.3	376.7
20	05/04/2022	233.1	427.1
21	06/04/2022	404.6	637.8
22	07/04/2022	453.8	667.3
23	08/04/2022	458.3	656.8
24	09/04/2022	378.7	598.7
25	10/04/2022	117.1	341.3
26	11/04/2022	141.6	346.8
27	12/04/2022	93.9	417.6
28	13/04/2022	109.3	417.5
29	14/04/2022	124.1	404.6
30	15/04/2022	103.9	455
31	16/04/2022	178.8	452.3
32	17/04/2022	154.4	480.7
33	18/04/2022	261	518.2
34	19/04/2022	301	573.3
35	20/04/2022	202.8	470.2
36	21/04/2022	131	442.9
37	22/04/2022	99.4	433.8
38	23/04/2022	136.9	489.1
39	24/04/2022	94.7	418.7
40	25/04/2022	286	497.9
41	26/04/2022	195.2	546.6
42	27/04/2022	234.1	501.7
43	28/04/2022	227.3	569.2
44	29/04/2022	450.7	269.1
45	30/04/2022	142.4	421.2
46	01/05/2022	160.1	479.8
47	02/05/2022	156.1	447.8
48	03/05/2022	135.5	542.9
49	04/05/2022	27.1	653.3
50	05/05/2022	0.1	239.2
51	06/05/2022	106.6	657.5
52	07/05/2022	124.3	602.8
53	08/05/2022	228.1	614.9
54	09/05/2022	220.6	606.3
55	10/05/2022	146.2	445.7
56	11/05/2022	217.7	467.8
57	12/05/2022	123.4	445
58	13/05/2022	160.9	467.2
59	14/05/2022	101.6	428.9
60	15/05/2022	227.5	496.4
61	16/05/2022	169	597.5
62	17/05/2022	281.4	571.4
63	18/05/2022	253.8	549.3
64	19/05/2022	121.2	593.5
65	20/05/2022	135	464.6
66	21/05/2022	230.6	463.2
67	22/05/2022	151.3	417.5
68	23/05/2022	142.7	549.1
69	24/05/2022	168	511
70	25/05/2022	246.4	523.7
71	26/05/2022	262.7	622.7
72	27/05/2022	154	506.7
73	28/05/2022	123.3	519.7
74	29/05/2022	179.9	513.1
75	30/05/2022	157.4	464.8
76	31/05/2022	73.4	504.8
77	01/06/2022	72.8	494.9
78	02/06/2022	186.1	462.4
79	03/06/2022	49.9	514.2
80	04/06/2022	0	559.8
81	05/06/2022	29.3	611
82	06/06/2022	26.8	605.6
83	07/06/2022	123.8	604
84	08/06/2022	97.5	593.3
85	09/06/2022	60.3	524.7
86	10/06/2022	73.2	521.5
87	11/06/2022	110.6	502.4
88	12/06/2022	171.1	538.4
89	13/06/2022	240.1	529.9
90	14/06/2022	290.4	528.8
91	15/06/2022	228.5	489
92	16/06/2022	256.7	486.4
93	17/06/2022	145.9	501.1
94	18/06/2022	100.7	552.1
95	19/06/2022	232.5	560.7
96	20/06/2022	192.6	529.7
97	21/06/2022	167.9	526.1
98	22/06/2022	205.2	537.5
99	23/06/2022	64.9	600.4
100	24/06/2022	0	731.5
101	25/06/2022	0.1	617.6
102	26/06/2022	13.6	679
103	27/06/2022	0	681.7
104	28/06/2022	0.1	682.9
105	29/06/2022	175	652.8
106	30/06/2022	84.5	600.5
107	01/07/2022	52.2	610.5
Data

Cell Formulas
Range	Formula
G2	G2	=FILTER(TableFlow[Date],TableFlow[Flow from River (m3)]=MAX(FILTER(TableFlow[Flow from River (m3)],(TableFlow[Date]>DATE($F$2,1,1))*(TableFlow[Date]<DATE($F$2,4,1)),"")),"")
H2	H2	=FILTER(TableFlow[Date],TableFlow[Flow to River (m3)]=MAX(FILTER(TableFlow[Flow to River (m3)],(TableFlow[Date]>DATE($F$2,1,1))*(TableFlow[Date]<DATE($F$2,4,1)),"")),"")
G3	G3	=FILTER(TableFlow[Date],TableFlow[Flow from River (m3)]=MAX(FILTER(TableFlow[Flow from River (m3)],(TableFlow[Date]>DATE($F$2,4,1))*(TableFlow[Date]<DATE($F$2,8,1)),"")),"")
H3	H3	=FILTER(TableFlow[Date],TableFlow[Flow to River (m3)]=MAX(FILTER(TableFlow[Flow to River (m3)],(TableFlow[Date]>DATE($F$2,4,1))*(TableFlow[Date]<DATE($F$2,8,1)),"")),"")

 

[wobble12]

Thank you for that. This continues to be throwing up strange results!
If I expand the sample data, it may better serve to show the anomolies:
First table shows the dates that the max values should occur, and the formulas you provided, with just the dates adjusted for each quarter.

	Date	Flow from River (m3)	Flow to River (m3)
2021​	Q1	23/01/2021​	08/01/2021​
	Q2	08/04/2021​	#SPILL!​
	Q3	08/07/2021​	20/07/2021​
	Q4	02/12/2021​	#SPILL!​
2022​	Q1	05/02/2022​	#SPILL!​
	Q2	08/04/2022​	10/09/2020​
			25/03/2021​
			24/06/2022​

This is from this data:

Date	Flow from River (m3)	Flow to River (m3)
12/06/2020	68.40	462.50
13/06/2020	53.30	508.80
14/06/2020	2.40	389.10
15/06/2020	51.40	448.20
16/06/2020	74.50	467.80
17/06/2020	171.20	471.10
18/06/2020	52.70	444.70
19/06/2020	124.20	454.70
20/06/2020	18.30	391.00
21/06/2020	0.50	437.90
22/06/2020	63.60	470.60
23/06/2020	140.00	510.20
24/06/2020	89.00	461.40
25/06/2020	0.10	388.40
26/06/2020	0.10	460.60
27/06/2020	0.10	444.80
28/06/2020	0.10	433.10
29/06/2020	0.20	446.60
30/06/2020	19.00	429.80
01/07/2020	137.80	539.00
02/07/2020	17.40	756.30
03/07/2020	21.10	791.10
04/07/2020	0.10	787.60
05/07/2020	0.10	755.00
06/07/2020	71.20	506.80
07/07/2020	0.10	0.20
08/07/2020	145.90	625.80
09/07/2020	110.10	698.80
10/07/2020	358.50	710.40
11/07/2020	290.00	314.80
12/07/2020	126.40	176.80
13/07/2020	140.00	447.40
14/07/2020	163.70	495.40
15/07/2020	184.50	441.10
16/07/2020	104.60	492.00
17/07/2020	0.10	415.40
18/07/2020	29.00	455.10
19/07/2020	68.30	422.70
20/07/2020	94.80	446.50
21/07/2020	76.20	418.10
22/07/2020	48.20	409.40
23/07/2020	40.30	398.30
24/07/2020	44.50	431.20
25/07/2020	474.70	241.70
26/07/2020	83.00	392.60
27/07/2020	154.40	431.30
28/07/2020	337.40	377.70
29/07/2020	548.90	378.80
30/07/2020	84.70	415.70
31/07/2020	0.00	128.60
01/08/2020	0.00	0.20
02/08/2020	4.20	0.50
03/08/2020	6.90	1.30
04/08/2020	6.80	2.50
05/08/2020	7.70	0.20
06/08/2020	7.00	0.20
07/08/2020	1.40	0.30
08/08/2020	0.00	0.30
09/08/2020	0.00	0.30
10/08/2020	0.00	0.30
11/08/2020	0.00	0.30
12/08/2020	0.20	0.80
13/08/2020	0.30	0.20
14/08/2020	1.50	0.20
15/08/2020	0.80	0.20
16/08/2020	0.60	0.30
17/08/2020	152.70	0.30
18/08/2020	93.50	0.30
19/08/2020	519.30	220.40
20/08/2020	75.10	483.40
21/08/2020	281.60	624.90
22/08/2020	292.20	691.40
23/08/2020	186.80	671.60
24/08/2020	180.20	697.60
25/08/2020	0.00	661.70
26/08/2020	0.00	620.40
27/08/2020	0.00	681.10
28/08/2020	0.00	677.70
29/08/2020	0.00	715.40
30/08/2020	0.00	744.50
31/08/2020	59.50	703.80
01/09/2020	268.90	584.90
02/09/2020	303.30	562.80
03/09/2020	42.90	657.20
04/09/2020	409.90	701.70
05/09/2020	521.70	749.60
06/09/2020	382.50	788.00
07/09/2020	116.00	787.90
08/09/2020	154.50	775.20
09/09/2020	91.80	726.30
10/09/2020	146.70	731.50
11/09/2020	346.60	727.20
12/09/2020	243.50	666.10
13/09/2020	121.40	591.10
14/09/2020	240.40	631.50
15/09/2020	162.40	162.40
16/09/2020	245.70	626.60
17/09/2020	205.30	552.20
18/09/2020	204.60	516.80
19/09/2020	320.70	646.50
20/09/2020	300.00	650.00
21/09/2020	267.50	675.30
22/09/2020	165.50	607.50
23/09/2020	105.50	726.60
24/09/2020	185.40	733.40
25/09/2020	27.10	873.40
26/09/2020	164.30	747.70
27/09/2020	159.10	682.70
28/09/2020	145.90	698.40
29/09/2020	128.30	651.50
30/09/2020	331.70	380.30
01/10/2020	282.10	579.60
02/10/2020	381.50	705.80
03/10/2020	207.20	779.90
04/10/2020	202.30	786.10
05/10/2020	165.60	724.20
06/10/2020	229.60	559.00
07/10/2020	253.20	617.30
08/10/2020	70.50	701.00
09/10/2020	0.00	698.70
10/10/2020	62.40	686.90
11/10/2020	270.00	702.70
12/10/2020	54.90	726.70
13/10/2020	62.20	756.90
14/10/2020	218.40	706.10
15/10/2020	313.60	708.70
16/10/2020	274.00	684.00
17/10/2020	294.90	671.50
18/10/2020	376.00	684.60
19/10/2020	314.00	661.50
20/10/2020	303.30	687.50
21/10/2020	389.80	672.30
22/10/2020	356.40	668.10
23/10/2020	394.50	714.40
24/10/2020	158.00	754.20
25/10/2020	151.70	710.70
26/10/2020	153.90	702.60
27/10/2020	305.40	720.40
28/10/2020	227.20	685.70
29/10/2020	163.60	687.20
30/10/2020	296.20	699.10
31/10/2020	190.50	761.40
01/11/2020	224.70	693.00
02/11/2020	188.80	661.00
03/11/2020	338.70	716.40
04/11/2020	363.60	718.60
05/11/2020	389.20	711.30
06/11/2020	393.40	700.30
07/11/2020	419.80	717.70
08/11/2020	359.00	665.30
09/11/2020	379.50	728.60
10/11/2020	363.60	703.40
11/11/2020	357.00	725.70
12/11/2020	341.40	751.00
13/11/2020	336.30	720.60
14/11/2020	366.00	735.10
15/11/2020	207.20	704.20
16/11/2020	311.10	731.20
17/11/2020	303.90	738.80
18/11/2020	288.00	728.80
19/11/2020	200.00	730.00
20/11/2020	165.20	738.10
21/11/2020	197.50	729.00
22/11/2020	43.30	728.40
23/11/2020	0.00	779.20
24/11/2020	75.20	821.50
25/11/2020	207.30	747.50
26/11/2020	212.20	678.50
27/11/2020	279.40	717.00
28/11/2020	288.00	728.10
29/11/2020	284.00	711.20
30/11/2020	282.30	699.70
01/12/2020	293.00	695.10
02/12/2020	317.20	684.90
03/12/2020	195.40	751.70
04/12/2020	77.50	803.60
05/12/2020	185.00	773.10
06/12/2020	152.90	766.50
07/12/2020	313.70	678.90
08/12/2020	266.90	717.30
09/12/2020	290.60	743.60
10/12/2020	230.50	719.90
11/12/2020	118.70	732.00
12/12/2020	209.00	749.60
13/12/2020	181.00	807.50
14/12/2020	201.10	745.80
15/12/2020	140.50	676.70
16/12/2020	180.20	706.10
17/12/2020	294.70	692.50
18/12/2020	187.10	685.40
19/12/2020	246.30	667.40
20/12/2020	233.60	638.80
21/12/2020	272.60	717.60
22/12/2020	25.60	170.20
23/12/2020	0.00	0.20
24/12/2020	0.00	0.20
25/12/2020	0.00	0.20
26/12/2020	0.00	0.20
27/12/2020	0.00	0.20
28/12/2020	0.00	0.20
29/12/2020	0.00	0.20
30/12/2020	0.00	0.20
31/12/2020	0.00	0.20
01/01/2021	97.90	0.10
02/01/2021	157.90	0.10
03/01/2021	19.70	443.10
04/01/2021	41.70	798.00
05/01/2021	182.90	821.50
06/01/2021	142.90	876.40
07/01/2021	196.30	858.80
08/01/2021	382.30	911.50
09/01/2021	163.10	622.20
10/01/2021	67.20	612.10
11/01/2021	232.60	728.30
12/01/2021	208.00	756.60
13/01/2021	26.10	869.90
14/01/2021	225.20	682.60
15/01/2021	106.60	593.70
16/01/2021	438.60	720.90
17/01/2021	218.10	744.00
18/01/2021	22.70	838.90
19/01/2021	402.10	842.60
20/01/2021	571.70	828.90
21/01/2021	300.70	842.80
22/01/2021	678.30	376.00
23/01/2021	752.20	192.70
24/01/2021	272.20	569.10
25/01/2021	315.70	636.40
26/01/2021	436.20	734.60
27/01/2021	140.10	851.30
28/01/2021	139.60	818.30
29/01/2021	241.10	720.90
30/01/2021	257.90	668.60
31/01/2021	142.40	624.00
01/02/2021	109.90	803.60
02/02/2021	67.30	748.50
03/02/2021	70.80	646.10
04/02/2021	142.30	693.80
05/02/2021	71.00	746.20
06/02/2021	130.10	776.80
07/02/2021	134.70	758.00
08/02/2021	23.90	762.60
09/02/2021	92.30	738.50
10/02/2021	18.70	697.90
11/02/2021	0.00	636.20
12/02/2021	57.20	564.20
13/02/2021	93.20	512.20
14/02/2021	94.40	621.40
15/02/2021	208.00	740.20
16/02/2021	216.40	656.30
17/02/2021	257.60	687.30
18/02/2021	271.70	685.70
19/02/2021	286.40	691.80
20/02/2021	271.30	727.10
21/02/2021	324.20	705.80
22/02/2021	165.80	617.80
23/02/2021	234.10	579.00
24/02/2021	195.50	582.80
25/02/2021	201.50	529.60
26/02/2021	220.10	573.90
27/02/2021	353.90	706.60
28/02/2021	358.80	722.50
01/03/2021	330.10	688.70
02/03/2021	315.10	619.90
03/03/2021	252.20	601.40
04/03/2021	277.30	577.70
05/03/2021	272.30	575.60
06/03/2021	298.90	614.60
07/03/2021	217.00	611.50
08/03/2021	240.10	558.20
09/03/2021	79.30	705.60
10/03/2021	254.10	254.10
11/03/2021	186.50	847.60
12/03/2021	189.50	705.60
13/03/2021	244.00	674.80
14/03/2021	313.90	687.70
15/03/2021	291.80	641.50
16/03/2021	156.50	510.30
17/03/2021	133.00	499.20
18/03/2021	119.00	532.30
19/03/2021	99.00	468.20
20/03/2021	150.20	524.60
21/03/2021	150.60	546.80
22/03/2021	198.00	504.40
23/03/2021	412.60	300.30
24/03/2021	285.70	489.40
25/03/2021	115.30	731.50
26/03/2021	96.40	590.20
27/03/2021	142.20	569.10
28/03/2021	105.10	571.90
29/03/2021	0.60	588.80
30/03/2021	141.60	653.40
31/03/2021	62.90	561.50
01/04/2021	107.40	552.90
02/04/2021	287.40	593.40
03/04/2021	474.50	587.80
04/04/2021	252.10	593.90
05/04/2021	247.20	578.60
06/04/2021	255.50	600.70
07/04/2021	467.20	236.20
08/04/2021	727.40	430.30
09/04/2021	178.90	546.60
10/04/2021	186.70	544.60
11/04/2021	98.30	598.60
12/04/2021	286.10	346.10
13/04/2021	191.60	460.50
14/04/2021	214.90	501.10
15/04/2021	283.60	514.60
16/04/2021	293.70	559.70
17/04/2021	256.50	568.80
18/04/2021	273.60	560.80
19/04/2021	298.30	578.60
20/04/2021	170.10	587.30
21/04/2021	181.70	587.40
22/04/2021	196.40	675.60
23/04/2021	98.10	614.90
24/04/2021	102.20	580.10
25/04/2021	149.30	597.50
26/04/2021	89.00	622.80
27/04/2021	85.60	549.80
28/04/2021	166.40	541.80
29/04/2021	100.10	514.00
30/04/2021	337.90	390.20
01/05/2021	203.80	575.20
02/05/2021	111.10	655.40
03/05/2021	148.80	589.20
04/05/2021	261.70	571.70
05/05/2021	219.50	557.50
06/05/2021	332.30	545.40
07/05/2021	123.80	645.30
08/05/2021	252.90	578.60
09/05/2021	310.20	603.60
10/05/2021	217.10	576.50
11/05/2021	191.50	602.60
12/05/2021	218.90	598.00
13/05/2021	179.80	589.10
14/05/2021	243.70	625.50
15/05/2021	170.00	593.90
16/05/2021	87.40	562.40
17/05/2021	4.70	621.10
18/05/2021	4.70	621.10
19/05/2021	0.90	611.40
20/05/2021	0.90	557.50
21/05/2021	27.10	666.00
22/05/2021	100.80	659.00
23/05/2021	161.30	673.60
24/05/2021	29.60	618.00
25/05/2021	22.90	644.80
26/05/2021	89.00	677.40
27/05/2021	141.20	553.60
28/05/2021	109.70	517.40
29/05/2021	106.60	530.60
30/05/2021	190.00	528.20
31/05/2021	158.90	542.40
01/06/2021	304.10	692.20
02/06/2021	263.10	525.80
03/06/2021	354.20	637.30
04/06/2021	215.90	533.50
05/06/2021	285.20	556.20
06/06/2021	228.80	559.50
07/06/2021	319.20	597.40
08/06/2021	210.70	547.70
09/06/2021	188.30	503.50
10/06/2021	161.60	483.70
11/06/2021	128.60	501.60
12/06/2021	147.30	499.30
13/06/2021	161.80	432.10
14/06/2021	239.60	551.80
15/06/2021	297.90	589.40
16/06/2021	302.60	531.00
17/06/2021	210.20	643.00
18/06/2021	116.20	571.40
19/06/2021	186.00	522.10
20/06/2021	234.70	535.00
21/06/2021	219.20	551.50
22/06/2021	305.20	456.50
23/06/2021	231.50	640.20
24/06/2021	69.50	648.80
25/06/2021	83.00	690.20
26/06/2021	99.80	682.90
27/06/2021	62.90	678.50
28/06/2021	83.10	561.50
29/06/2021	176.40	610.60
30/06/2021	291.40	621.30
01/07/2021	259.00	656.50
02/07/2021	333.10	669.90
03/07/2021	259.60	653.10
04/07/2021	240.90	464.40
05/07/2021	154.10	614.70
06/07/2021	124.40	720.00
07/07/2021	137.70	693.30
08/07/2021	537.50	627.00
09/07/2021	214.80	627.00
10/07/2021	196.20	678.40
11/07/2021	85.40	612.30
12/07/2021	79.50	696.40
13/07/2021	50.90	587.20
14/07/2021	44.40	588.20
15/07/2021	170.40	533.60
16/07/2021	154.20	607.60
17/07/2021	31.00	550.00
18/07/2021	90.90	353.40
19/07/2021	0.00	0.00
20/07/2021	408.30	1453.00
21/07/2021	109.70	588.70
22/07/2021	48.90	555.30
23/07/2021	224.00	538.20
24/07/2021	184.00	484.10
25/07/2021	176.90	471.40
26/07/2021	364.20	578.70
27/07/2021	377.60	594.90
28/07/2021	210.60	654.20
29/07/2021	274.10	633.30
30/07/2021	309.20	652.70
31/07/2021	215.00	452.10
01/08/2021	47.50	95.70
02/08/2021	0.00	0.60
03/08/2021	0.10	5.60
04/08/2021	0.00	6.80
05/08/2021	100.50	15.60
06/08/2021	0.10	15.60
07/08/2021	0.80	3.90
08/08/2021	1.00	12.50
09/08/2021	2.90	14.40
10/08/2021	35.10	23.90
11/08/2021	2.00	39.30
12/08/2021	331.50	48.50
13/08/2021	1.20	58.30
14/08/2021	1.60	53.50
15/08/2021	1.40	38.50
16/08/2021	186.20	60.40
17/08/2021	0.00	56.30
18/08/2021	77.80	258.10
19/08/2021	71.80	326.20
20/08/2021	92.00	417.90
21/08/2021	191.60	447.40
22/08/2021	81.20	512.50
23/08/2021	204.20	595.30
24/08/2021	287.90	381.50
25/08/2021	193.10	691.70
26/08/2021	170.00	720.60
27/08/2021	215.60	699.90
28/08/2021	160.60	568.40
29/08/2021	197.50	615.80
30/08/2021	287.80	667.60
31/08/2021	307.30	696.00
01/09/2021	419.10	472.30
02/09/2021	237.00	634.80
03/09/2021	237.90	680.80
04/09/2021	405.20	429.90
05/09/2021	300.60	652.80
06/09/2021	294.00	680.40
07/09/2021	327.70	701.20
08/09/2021	317.30	630.10
09/09/2021	193.60	677.10
10/09/2021	265.50	435.00
11/09/2021	139.60	546.10
12/09/2021	144.90	541.50
13/09/2021	313.30	428.70
14/09/2021	128.80	496.40
15/09/2021	250.10	638.70
16/09/2021	249.20	618.00
17/09/2021	334.00	629.50
18/09/2021	262.60	606.70
19/09/2021	250.50	602.30
20/09/2021	228.10	568.90
21/09/2021	145.30	507.10
22/09/2021	257.30	598.60
23/09/2021	134.80	545.50
24/09/2021	69.50	648.80
25/09/2021	142.20	472.70
26/09/2021	203.00	357.90
27/09/2021	313.50	324.60
28/09/2021	62.00	564.30
29/09/2021	299.30	723.00
30/09/2021	132.60	638.00
01/10/2021	61.20	537.20
02/10/2021	179.90	634.10
03/10/2021	235.90	585.90
04/10/2021	190.80	536.20
05/10/2021	29.70	689.00
06/10/2021	35.00	731.20
07/10/2021	0.10	678.20
08/10/2021	17.10	661.90
09/10/2021	59.60	643.60
10/10/2021	36.70	609.00
11/10/2021	212.80	556.10
12/10/2021	231.40	539.00
13/10/2021	271.30	569.50
14/10/2021	234.80	552.80
15/10/2021	143.70	520.40
16/10/2021	154.60	505.00
17/10/2021	145.10	499.40
18/10/2021	137.80	552.60
19/10/2021	59.00	700.30
20/10/2021	34.70	608.60
21/10/2021	180.00	631.30
22/10/2021	206.70	569.30
23/10/2021	266.40	627.50
24/10/2021	207.70	607.40
25/10/2021	200.80	590.50
26/10/2021	96.10	544.90
27/10/2021	96.60	538.80
28/10/2021	118.90	557.80
29/10/2021	90.80	530.90
30/10/2021	24.10	603.40
31/10/2021	10.90	711.10
01/11/2021	78.30	611.80
02/11/2021	10.50	697.60
03/11/2021	38.70	724.70
04/11/2021	67.20	722.30
05/11/2021	104.70	409.80
06/11/2021	208.80	548.60
07/11/2021	229.80	531.40
08/11/2021	156.30	553.70
09/11/2021	129.10	548.30
10/11/2021	145.30	536.90
11/11/2021	196.20	512.80
12/11/2021	163.70	534.60
13/11/2021	179.40	548.80
14/11/2021	127.50	505.80
15/11/2021	219.60	567.20
16/11/2021	244.50	606.70
17/11/2021	163.00	641.60
18/11/2021	80.00	610.70
19/11/2021	145.20	587.40
20/11/2021	205.20	564.20
21/11/2021	202.50	595.20
22/11/2021	267.10	619.00
23/11/2021	216.60	610.10
24/11/2021	275.20	613.00
25/11/2021	222.90	630.20
26/11/2021	216.90	677.60
27/11/2021	61.20	718.30
28/11/2021	174.90	692.20
29/11/2021	205.60	558.20
30/11/2021	103.10	598.70
01/12/2021	24.60	640.00
02/12/2021	389.90	432.10
03/12/2021	99.20	619.70
04/12/2021	37.60	562.00
05/12/2021	12.80	673.60
06/12/2021	20.60	622.40
07/12/2021	65.90	674.90
08/12/2021	125.70	661.90
09/12/2021	55.90	721.40
10/12/2021	41.30	671.80
11/12/2021	16.30	697.10
12/12/2021	54.60	659.10
13/12/2021	12.60	671.60
14/12/2021	77.40	659.50
15/12/2021	100.50	600.50
16/12/2021	168.20	587.30
17/12/2021	306.60	656.00
18/12/2021	348.70	512.80
19/12/2021	323.70	523.70
20/12/2021	213.90	491.20
21/12/2021	198.90	429.00
22/12/2021	77.50	241.70
23/12/2021	1.70	21.70
24/12/2021	0.70	0.00
25/12/2021	0.00	0.00
26/12/2021	0.00	0.00
27/12/2021	0.00	0.00
28/12/2021	0.00	0.00
29/12/2021	0.00	0.00
30/12/2021	0.00	0.00
31/12/2021	0.00	0.00
01/01/2022	0.00	0.00
02/01/2022	0.00	0.00
03/01/2022	1.00	0.10
04/01/2022	186.30	0.00
05/01/2022	136.80	0.10
06/01/2022	56.60	367.50
07/01/2022	136.10	596.40
08/01/2022	38.40	617.70
09/01/2022	82.40	533.90
10/01/2022	0.00	565.70
11/01/2022	75.70	508.90
12/01/2022	165.30	400.50
13/01/2022	45.90	411.60
14/01/2022	1.30	508.00
15/01/2022	131.40	487.90
16/01/2022	112.70	437.60
17/01/2022	32.90	191.30
18/01/2022	101.60	436.40
19/01/2022	121.80	403.10
20/01/2022	151.10	413.50
21/01/2022	80.00	434.50
22/01/2022	92.80	476.10
23/01/2022	122.90	417.20
24/01/2022	0.00	416.20
25/01/2022	155.10	478.90
26/01/2022	340.90	555.20
27/01/2022	298.90	577.50
28/01/2022	200.90	578.60
29/01/2022	176.10	522.70
30/01/2022	241.60	589.90
31/01/2022	270.20	529.10
01/02/2022	169.60	536.50
02/02/2022	269.80	572.20
03/02/2022	287.80	576.00
04/02/2022	333.40	305.00
05/02/2022	353.80	523.60
06/02/2022	178.10	586.50
07/02/2022	171.80	555.40
08/02/2022	12.70	618.70
09/02/2022	0.00	570.10
10/02/2022	93.20	486.30
11/02/2022	89.00	442.60
12/02/2022	59.60	462.90
13/02/2022	66.80	438.30
14/02/2022	117.10	503.10
15/02/2022	247.30	571.40
16/02/2022	135.10	540.80
17/02/2022	210.30	529.30
18/02/2022	89.50	697.50
19/02/2022	68.60	518.90
20/02/2022	0.10	580.80
21/02/2022	0.00	631.70
22/02/2022	91.60	605.30
23/02/2022	8.60	627.40
24/02/2022	0.10	697.60
25/02/2022	0.00	693.60
26/02/2022	142.00	605.20
27/02/2022	289.30	575.60
28/02/2022	184.40	605.00
01/03/2022	271.50	597.90
02/03/2022	134.80	568.40
03/03/2022	187.80	577.60
04/03/2022	44.20	650.30
05/03/2022	135.50	606.20
06/03/2022	197.70	575.50
07/03/2022	235.30	603.80
08/03/2022	262.60	660.00
09/03/2022	192.40	653.30
10/03/2022	331.00	584.80
11/03/2022	164.10	548.90
12/03/2022	179.90	488.10
13/03/2022	142.60	564.50
14/03/2022	229.50	563.90
15/03/2022	253.90	560.40
16/03/2022	174.10	647.50
17/03/2022	84.00	581.00
18/03/2022	183.30	525.00
19/03/2022	251.50	570.30
20/03/2022	214.20	524.00
21/03/2022	177.80	501.90
22/03/2022	100.80	483.40
23/03/2022	109.60	464.60
24/03/2022	81.30	444.70
25/03/2022	31.40	430.80
26/03/2022	107.10	498.90
27/03/2022	176.80	526.80
28/03/2022	89.20	520.70
29/03/2022	53.00	536.10
30/03/2022	0.00	555.00
31/03/2022	0.00	544.10
01/04/2022	53.90	444.40
02/04/2022	99.90	403.10
03/04/2022	148.00	374.20
04/04/2022	90.30	376.70
05/04/2022	233.10	427.10
06/04/2022	404.60	637.80
07/04/2022	453.80	667.30
08/04/2022	458.30	656.80
09/04/2022	378.70	598.70
10/04/2022	117.10	341.30
11/04/2022	141.60	346.80
12/04/2022	93.90	417.60
13/04/2022	109.30	417.50
14/04/2022	124.10	404.60
15/04/2022	103.90	455.00
16/04/2022	178.80	452.30
17/04/2022	154.40	480.70
18/04/2022	261.00	518.20
19/04/2022	301.00	573.30
20/04/2022	202.80	470.20
21/04/2022	131.00	442.90
22/04/2022	99.40	433.80
23/04/2022	136.90	489.10
24/04/2022	94.70	418.70
25/04/2022	286.00	497.90
26/04/2022	195.20	546.60
27/04/2022	234.10	501.70
28/04/2022	227.30	569.20
29/04/2022	450.70	269.10
30/04/2022	142.40	421.20
01/05/2022	160.10	479.80
02/05/2022	156.10	447.80
03/05/2022	135.50	542.90
04/05/2022	27.10	653.30
05/05/2022	0.10	239.20
06/05/2022	106.60	657.50
07/05/2022	124.30	602.80
08/05/2022	228.10	614.90
09/05/2022	220.60	606.30
10/05/2022	146.20	445.70
11/05/2022	217.70	467.80
12/05/2022	123.40	445.00
13/05/2022	160.90	467.20
14/05/2022	101.60	428.90
15/05/2022	227.50	496.40
16/05/2022	169.00	597.50
17/05/2022	281.40	571.40
18/05/2022	253.80	549.30
19/05/2022	121.20	593.50
20/05/2022	135.00	464.60
21/05/2022	230.60	463.20
22/05/2022	151.30	417.50
23/05/2022	142.70	549.10
24/05/2022	168.00	511.00
25/05/2022	246.40	523.70
26/05/2022	262.70	622.70
27/05/2022	154.00	506.70
28/05/2022	123.30	519.70
29/05/2022	179.90	513.10
30/05/2022	157.40	464.80
31/05/2022	73.40	504.80
01/06/2022	72.80	494.90
02/06/2022	186.10	462.40
03/06/2022	49.90	514.20
04/06/2022	0.00	559.80
05/06/2022	29.30	611.00
06/06/2022	26.80	605.60
07/06/2022	123.80	604.00
08/06/2022	97.50	593.30
09/06/2022	60.30	524.70
10/06/2022	73.20	521.50
11/06/2022	110.60	502.40
12/06/2022	171.10	538.40
13/06/2022	240.10	529.90
14/06/2022	290.40	528.80
15/06/2022	228.50	489.00
16/06/2022	256.70	486.40
17/06/2022	145.90	501.10
18/06/2022	100.70	552.10
19/06/2022	232.50	560.70
20/06/2022	192.60	529.70
21/06/2022	167.90	526.10
22/06/2022	205.20	537.50
23/06/2022	64.90	600.40
24/06/2022	0.00	731.50
25/06/2022	0.10	617.60
26/06/2022	13.60	679.00
27/06/2022	0.00	681.70
28/06/2022	0.10	682.90
29/06/2022	175.00	652.80
30/06/2022	84.50	600.50
01/07/2022	52.20	610.50
02/07/2022	142.60	647.20
03/07/2022	0.00	677.90
04/07/2022	0.00	0.00
05/07/2022	0.00	0.00
06/07/2022	0.00	0.00

Just hope I'm not missing something really simple.

 

[wobble12]

It does appear that the Flow to River column is the one that is struggling to work for some reason.

 

[Fluff]

The problem is you have multiple matches for the MAX values, try

=INDEX(SORT(FILTER(TableFlow[[Date]:[Flow to River (m3)]],(TableFlow[Date]>=DATE($L$20,1,1))*(TableFlow[Date]<DATE($L$20,4,1)),""),2,-1),1,1)

and

=INDEX(SORT(FILTER(TableFlow[[Date]:[Flow to River (m3)]],(TableFlow[Date]>=DATE($L$20,1,1))*(TableFlow[Date]<DATE($L$20,4,1)),""),3,-1),1,1)

 

[wobble12]

Fantastic, that works a treat.

Thank you very much!

Solution marked up.

 

[Fluff]

You're welcome & thanks for the feedback.