Calculate largest value in column year to date?

[Ironman]

Hi

Column A12 to A23357 contains date values.

Column E12 to E23357 are either blank or contain time values in format m:ss, which are formulas Col C/Col D from the same row.

The below is a sample from Oct 1 onwards.

Exercise Log test.xlsm
	A	B	C	D	E
8686	Fri, 1 Oct 2021	OTHER (IB)
8687	Sat, 2 Oct 2021	REST
8688	Sun, 3 Oct 2021	OTHER (IB)
8689	Mon, 4 Oct 2021	Cullingworth Rd/Viaduct/ Stn Road/Old Allen Road Back Lane/Wilsden Rd/ Cottingley Rd/Lee Lane/ Cross Lane/Coplowe Ln/ Crack Lane/Main Street/ Harden Ln/Mill Hill Top/ Wilsden Rd/Mad Mile/ Greenside Lane (21/02/2020)	10.6	2:25:34	13:44
8690	Tue, 5 Oct 2021	OTHER (IB)
8691	Wed, 6 Oct 2021	REST
8692	Thu, 7 Oct 2021	OTHER (IB)
8693	Fri, 8 Oct 2021	Cullingworth Rd/Haworth Rd/Flappit/L Halifax Rd/ Trough Ln/Denholme Rd/ Station Rd (Oxenhope)/ Moorhse Ln/R Marsh Ln (Haworth)/Sun St/ Bridgehouse Ln/Brow Rd Brow Top Rd/Hawrth Rd Turf Ln/Station Road/ Greenside Lane	9.9	2:22:41	14:25
8694	Sat, 9 Oct 2021	OTHER (IB)
8695	Sun, 10 Oct 2021	REST
8696	Mon, 11 Oct 2021	OTHER (IB)
8697	Tue, 12 Oct 2021	Harrogate (Centre - Inn On Cheltenham Parade)/ Valley Park/Pinewoods/ Crag Ln by RHS, Harlow Carr/Nursery Ln/Crag Ln (again)/Otley Road/Back	6.7	1:43:47	15:29
8698	Wed, 13 Oct 2021	OTHER (IB)
8699	Thu, 14 Oct 2021	REST
8700	Fri, 15 Oct 2021	OTHER (IB)
8701	Sat, 16 Oct 2021	Hallas Br/Down Bents Ln Harden Lane/Smithy Ln/ Lee Farm/Black Hills/ Golf Course/R down Beck Foot Lane/Wagon Lane/ Up LLC to 5-Rise Locks/ Back to 3-Rise Locks & over Bridge/Brown Cow/ Main Road all the way back home (25/08/2005)	10.4	2:33:41	14:47
Training Log

Cell Formulas
Range	Formula
E8689,E8701,E8697,E8693	E8689	=D8689/C8689

(Although Rows 8710 downwards have yet to be filled, they will eventually be).

What I'd be grateful for is a formula that returns the lowest value in Col E i.e. the fastest pace in the current year to date (for 2022 it will be 2022 year to date).

Many thanks!

 

[Ironman]

Peter, you are a genius! You were absolutely right and your formula works beautifully now, thank you!!!

 

[Peter_SSs]

You're welcome, glad we got there in the end.

I've just installed MS365

That is a bit confusing since your profile was previously showing 365, 2019 as your office versions.

 

[Ironman]

Yes, I'm sorry about that, it was in the pipeline but my email addresses wouldn't satisfy MS to qualify for a discount at the time - I've since satisfied them and have obviously now completed the switch. Even without the discount MS365 is incredible value for money.