Extract min/max values from a range of cells which share the same day

[pete1229]

I have 3 columns: "A" contains the day, "B" contains the hours, and "L" contains some values. For each day, there are 24 hours and these are associated with either negative or positive values. I would like to extract the minimum and maximum value of only the positive values (i.e. >=0) from column "L" for each day and paste them to another column as shown in the image. There are 365 days so 8760 hours and values. What is the best method to achieve this?

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A	B										L	M	N	O	P	Q
1	1	1														Min	Max
2	1	2										59			1	20	92
3	1	3										48			2	14	97
4	1	4										-69
5	1	5										0
6	1	6										20
7	1	7										-51
8	1	8										59
9	1	9										83
10	1	10										87
11	1	11										-14
12	1	12										92
13	1	13										87
14	1	14										77
15	1	15										-86
16	1	16										37
17	1	17										-29
18	1	18										91
19	1	19										23
20	1	20										-51
21	1	21										-22
22	1	22										-79
23	1	23										-44
24	1	24										-61
25	2	1										-5
26	2	2										27
27	2	3										-58
28	2	4										-5
29	2	5										77
30	2	6										-92
31	2	7										-2
32	2	8										-74
33	2	9										97
34	2	10										79
35	2	11										-97
36	2	12										79
37	2	13										-85
38	2	14										-13
39	2	15										80
40	2	16										15
41	2	17										23
42	2	18										91
43	2	19										-97
44	2	20										-75
45	2	21										33
46	2	22										92
47	2	23										50
48	2	24										86
49	2	24										14
Main

Cell Formulas
Range	Formula
P2:P3	P2	=MINIFS(L:L,A:A,O2,L:L,">0")
Q2:Q3	Q2	=MAXIFS(L:L,A:A,O2)

 

[pete1229]

You're a genius! Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.