Formula to return to column header for most frequent result

[saraapple]

Below is my data and my formulas so far:

Time Changes 2021 NEW.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
4	Permanent Window	Most frequent change		Store Name	Store Name	0700:0900	0800:1000	0900:1100	1000:1200	1100:1300	1200:1400	1300:1500	1400:1600	1500:1700	1600:1800
5	0800:1000	18	#VALUE!	25	BECKTON			6	18	1	2	1	1
TIME CHANGES BY STORE

Cell Formulas
Range	Formula
A5	A5	=VLOOKUP(D5,'Permanent Windows'!A:E,5,FALSE)
B5	B5	=MAX(F5:O5)
C5	C5	=IF(B5=F5:O5,(MATCH(B5,O4,0)))

As you can see I am struggling with the formula for C5, I want it to return cell I4 as this is the column that my max range is found 18 - basically which ever column with the most time changes I want to bring back for the, for example data I want it to return "10:00 12:00" as this is the time most frequently used.

Any help greatly appreciated as always.
Thank you for your time
Sara

 

[jorismoerings]

Hi,

try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
4	Permanent Window	Most frequent change		Store Name	Store Name	0700:0900	0800:1000	0900:1100	1000:1200	1100:1300	1200:1400	1300:1500	1400:1600	1500:1700	1600:1800
5		18	1000:1200	25	BECKTON			6	18	1	2	1	1
Sheet4

Cell Formulas
Range	Formula
B5	B5	=MAX(F5:O5)
C5	C5	=INDEX(F4:O4,MATCH(B5,F5:O5,0))

 

[saraapple]

Perfect thank you. I was heading in that direction, it just would have taken me a very long time to get there!
Sara

 

[jorismoerings]

glad I could speed up the process. Remember to mark it as solution if this is done