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:

[TABLE="width: 281"]
<tbody>[TR]
[TD]Unique ID[/TD]
[TD]Total Cost[/TD]
[TD]Desired Outcome[/TD]
[/TR]
[TR]
[TD]1x1[/TD]
[TD]$2,944.47[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]1x1[/TD]
[TD]$246.13[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]1x1[/TD]
[TD]$0.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]1x1[/TD]
[TD]$36.00[/TD]
[TD]$36.00[/TD]
[/TR]
[TR]
[TD]1x1[/TD]
[TD]$1,500.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]1x1[/TD]
[TD]$545.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]2x2[/TD]
[TD]$1,835.06[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]2x2[/TD]
[TD]$0.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]2x2[/TD]
[TD]$3.00[/TD]
[TD]$3.00[/TD]
[/TR]
[TR]
[TD]2x2[/TD]
[TD]$202.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]2x2[/TD]
[TD]$21.74[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]3x3[/TD]
[TD]$5.00[/TD]
[TD]$5.00[/TD]
[/TR]
[TR]
[TD]3x3[/TD]
[TD]$235.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]3x3[/TD]
[TD]$0.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]3x3[/TD]
[TD]$0.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]3x3[/TD]
[TD]$0.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]3x3[/TD]
[TD]$1,363.20[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD]Continued[/TD]
[TD]Continued[/TD]
[TD]Continued[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[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)