Minimum value if a column contains text

[mxcman]

I have a couple of data sets that I need to determine the minimum and maximum values. I have tried (and failed) to configure a formula that essentially says, IF Column A (Keys) contains "P:", then give me the minimum/maximum value of the corresponding value in Column B (Partial). The data sets are below.

Comparing "EC SFV 345"("EC") to "ECSFV345R"("KN")
Using a 10 second interval size.
Using a session duration of 78 seconds.
Keys Found: POQ1,2WY
Keys	Partial	Exact	Occrnce	NonOccrn
P:	100	100	100	na
O:	100	100	100	na
Q:	100	100	100	100
1:	75	75	66.67	50
,:	78.82	62.5	85.71	50
2:	100	100	100	100
W:	100	100	100	100
Y:	87.5	87.5	0	87.5
Comparing " ECSFV310"("BW") to "EC SFV310R"("KL") Using a 10 second interval size. Using a session duration of 62 seconds. Keys Found: \PO/Q1,2W Keys Partial Exact Occrnce NonOccrn \: 0 0 0 0 P: 96.43 85.7 100 na O: 95 71.4 100 na /: 0 0 0 0 Q: 100 100 100 100 1: 78.57 71.4 83.33 50 ,: 79.21 42.9 100 100 2: 92.86 85.7 100 100 W: 85.71 85.7 80 66.67 <colgroup><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

I know the minimum of "P:" is 96.43 and the maximum is 100, but I will be working with several data sets.

 

[DRSteele]

I think this might be what you're looking for. I'm not sure if you really mean to make reference to the entire column A, so I just included a range.

	A	B	C	D	E	F	G	H	I
1	Keys	Partial						Min	Max
2	P:	100					p:	96.43	100
3	O:	100
4	Q:	100
5	1:00	75
6	,:	78.82
7	2:00	100
8	W:	100
9	Y:	87.5
10
11	Keys	Partial
12	\:	0
13	P:	96.43
14	O:	95
15	/:	0
16	Q:	100
17	1:00	78.57
18	,:	79.21
19	2:00	92.86
20	W:	85.71

<colgroup><col style="******* 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet54​

Worksheet Formulas Cell Formula H2 =1/AGGREGATE(14,6,1/((G2=A1:A20)*B1:B20),1) I2 =AGGREGATE(14,6,(G2=A1:A20)*B1:B20,1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[mxcman]

I think this might be what you're looking for. I'm not sure if you really mean to make reference to the entire column A, so I just included a range.

	A	B	C	D	E	F	G	H	I
1	Keys	Partial						Min	Max
2	P:	100					p:	96.43	100
3	O:	100
4	Q:	100
5	1:00	75
6	,:	78.82
7	2:00	100
8	W:	100
9	Y:	87.5
10
11	Keys	Partial
12	\:	0
13	P:	96.43
14	O:	95
15	/:	0
16	Q:	100
17	1:00	78.57
18	,:	79.21
19	2:00	92.86
20	W:	85.71

<tbody>
</tbody>

Sheet54​

Worksheet Formulas Cell Formula H2 =1/AGGREGATE(14,6,1/((G2=A1:A20)*B1:B20),1) I2 =AGGREGATE(14,6,(G2=A1:A20)*B1:B20,1) <tbody> </tbody>

<tbody>
</tbody>

But, is there an option to not remove the text?