Finding the minimum value that is not zero for each sub-set of data

[phillipsdp11]

Hi -

I have a data set that is sorted by Member ID and each Member ID can have multiple transactions. In my desired outcome I only want the non-zero minimum value displayed for the group next to the corresponding transaction in each subset of Member ID's. See example below:

Unique ID	Total Cost	Desired Outcome
1x1	$2,944.47	$0.00
1x1	$246.13	$0.00
1x1	$0.00	$0.00
1x1	$36.00	$36.00
1x1	$1,500.00	$0.00
1x1	$545.00	$0.00
2x2	$1,835.06	$0.00
2x2	$0.00	$0.00
2x2	$3.00	$3.00
2x2	$202.00	$0.00
2x2	$21.74	$0.00
3x3	$5.00	$5.00
3x3	$235.00	$0.00
3x3	$0.00	$0.00
3x3	$0.00	$0.00
3x3	$0.00	$0.00
3x3	$1,363.20	$0.00
Continued	Continued	Continued

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

 

[phillipsdp11]

I have solved my own problem, answer below:

=MIN(IF($A2=$A$2:$A$1248,IF($B$2:$B$1248=0,MAX($B$2:$B$1248),$B$2:$B$1248)))

 

[phillipsdp11]

Correction above formula repeats minimum value, this answer only puts minimum value next to the corresponding row with the minimum value:

=IF(AND(MIN(IF($A2=$A$2:$A$1248,IF($B$2:$B$1248=0,MAX($B$2:$B$1248),$B$2:$B$1248)))=B2,MIN(IF($A2=$A$2:$A$1248,IF($B$2:$B$1248=0,MAX($B$2:$B$1248),$B$2:$B$1248))),0)