Return Column header for MAX/MIN Value

[kitm]

I have a spreadsheet that has the counts the number of instances on a daily basis.
Under the table I have a breakout that finds the MAX and MIN number of instances. I would like to add a second cell next to that that returns the column header (Date) for the max or min value that is found.
Im struggling with the formula to get the array right or return the column header instead of the column number.

Table:

Zero Hero Tracking 2024.xlsx
	D			G	H	I	J	K																						AG
1	BR			6/1	6/3	6/4	6/5	6/6																						TOTAL
2	391			8	10	6	4	6																						34
3	436			6	5	3	0	3																						17
4	912			0	0	1	1	1																						3
5	922			2	2	3	2	3																						12
6	931			1	2	5	0	0																						8
7	933			7	3	4	3	16																						33
8	934			1	2	14	5	8																						30
9				25	24	36	15	37																						137
11	482			3	18	3	4	8																						36
12	905			4	3	2	2	1																						12
13	910			16	6	5	4	2																						33
14	913			2	3	3	2	2																						12
15	935			1	11	5	6	10																						33
16	936			6	4	4	8	4																						26
17				32	45	22	26	27																						152
18	494			3	2	1	1	4																						11
19	906			2	0	1	3	1																						7
20	909			0	2	1	2	1																						6
21	911			4	2	5	3	2																						16
22	914			3	5	13	3	33																						57
23	929			1	7	2	9	6																						25
24				13	18	23	21	47																						122
25	491			9	8	3	10	4																						34
26	907			10	5	7	2	6																						30
27	908			4	4	4	3	6																						21
28	927			4	8	16	14	6																						48
29	928			15	7	4	6	8																						40
30				42	32	34	35	30																						173
31	489			2	4	6	8	3																						23
32	490			3	1	2	5	2																						13
33	917			3	3	6	3	2																						17
34	919			3	2	3	0	4																						12
35	930			4	1	2	1	0																						8
36				15	11	19	17	11																						73
37	481			2	6	5	3	4																						20
38	916			1	1	3	2	2																						9
39	920			3	3	2	2	3																						13
40	924			5	2	3	2	5																						17
41	932			0	3	1	2	4																						10
42				11	15	14	11	18																						69
43				138	145	148	125	170																						726
June 2024

Breakout:

Zero Hero Tracking 2024.xlsx
	F	G	H
50	Best Day	170	6/6/2024
51	Worst Day	125	6/5/2024
June 2024

Column G is the min and max of the total row (red) in the main table. Column H is the date on which the min/max value occurs. Right now I am having to manually find what day the max/min is and enter it. I would really like it to be a formula because the table will expand to include every day of the month. And I just can't seem to find the right index formula to make it work.

 

[Cubist]

Try:

Book1
	F	G	H
50	Best Day	170	6/6/24
51	Worst Day	125	6/5/24
Sheet8

Cell Formulas
Range	Formula
G50	G50	=MAX(G43:AF43)
H50:H51	H50	=INDEX($G$1:$K$1,1,MATCH(G50,$G$43:$K$43,0))
G51	G51	=MIN(G43:AF43)

 

[awoohaw]

try:

Book1
	A	B	C	D	E	F	G	H
48
49
50						Best Day	170	2024-06-06
51						Worst Day	125	2024-06-05
52
Sheet1

Cell Formulas
Range	Formula
G50	G50	=MAX(G43:AF43)
H50:H51	H50	=INDEX($G$1:$K$1,MATCH($G50,$G$43:$K$43,0))
G51	G51	=MIN(G43:AF43)

 

[kitm]

Thank you both, that worked!