how to catch minimum in column with same condition

[Valley]

Dear,

I need to catch a minimum value from a column with same condition.

For example.
A B C
123 0.5 0.5
123 0.8 0.5
123 0.6 0.5
123 1.0 0.5
124 0.3 0.3
124 0.5 0.3
124 0.6 0.3
124 1.1 0.3

Below example,
Same condition: A
Value: B
I need get result like C

Please help to give a solution, thanks in advance!

Valley

 

[JoeMo]

Dear,

I need to catch a minimum value from a column with same condition.

For example.
A B C
123 0.5 0.5
123 0.8 0.5
123 0.6 0.5
123 1.0 0.5
124 0.3 0.3
124 0.5 0.3
124 0.6 0.3
124 1.1 0.3

Below example,
Same condition: A
Value: B
I need get result like C

Please help to give a solution, thanks in advance!

Valley

Try this. Copy formula in C1 down column C as far as you need to go after changing the absolute references accordingly.

Excel Workbook
	A	B	C
1	123	0.5	0.5
2	123	0.8	0.5
3	123	0.6	0.5
4	123	1	0.5
5	124	0.3	0.3
6	124	0.5	0.3
7	124	0.6	0.3
8	124	1.1	0.3
Sheet10

 

[Valley]

Try this. Copy formula in C1 down column C as far as you need to go after changing the absolute references accordingly.

Excel Workbook
	A	B	C
1	123	0.5	0.5
2	123	0.8	0.5
3	123	0.6	0.5
4	123	1	0.5
5	124	0.3	0.3
6	124	0.5	0.3
7	124	0.6	0.3
8	124	1.1	0.3
Sheet10

Many thanks for your helps.
BTW, how to calculate without zero.

Regards,
Valley

 

[Peter_SSs]

BTW, how to calculate without zero.

Please explain.

 

[Valley]

Please explain.

A B C
123 0.5 0.5
123 0.8 0.5
123 0.6 0.5
123 1.0 0.5
124 0.3 0.3
124 0.5 0.3
124 0.6 0.3
124 1.1 0.3
125 1.4 0.8
125 1.2 0.8
125 1.0 0.8
125 1.5 0.8
125 0.8 0.8
125 0 0.8

like above, please help to give a solution without delete row including zero, thanks.

Valley

 

[Aladin Akyurek]

A B C
123 0.5 0.5
123 0.8 0.5
123 0.6 0.5
123 1.0 0.5
124 0.3 0.3
124 0.5 0.3
124 0.6 0.3
124 1.1 0.3
125 1.4 0.8
125 1.2 0.8
125 1.0 0.8
125 1.5 0.8
125 0.8 0.8
125 0 0.8

like above, please help to give a solution without delete row including zero, thanks.

Valley

C2, control+shift+enter and copy down:

=MIN(IF($A$2:$A$15=A2,IF($B$2:$B$15>0,$B$2:$B$15)))