Returning ROW number from MIN value

[KeithMJ]

This is in furtherance of my last question about returning the ROW number from a MAX value, but now I require a MIN value. I'm tearing my hair out trying to get this to work. I need to find the smallest number in a column (F) that is greater than zero and reference the name in B2.
I have tried =INDEX($B$2:$B$6,MATCH(SMALL($b$2:$b$6,COUNTIF($f$2:$f$6,0)+1))) but the program tells me I have too few arguments in there. I also need to know how to handle the situation when two (or more) names have sold the same number of units.

Help would be much appreciated! An example of the workbook is attached.

Thanks,
Keith Jones.

[zbor]

This will return you row of first minimum value:

=MATCH(MIN(F:F), F:F, 0)

[martindwilson]

=INDEX($B$2:$B$6,MATCH(SMALL($F$2:$F$6,COUNTIF($F$2:$F$6,0)+1),$F$2:$F$6,0)) corrects your formula for >0 if you have 2 or more matches then you will have to small ,1,2,3 ect
=INDEX($B$2:$B$6,MATCH(SMALL($F$2:$F$6,COUNTIF($F$2:$F$6,0)+2),$F$2:$F$6,0))
=INDEX($B$2:$B$6,MATCH(SMALL($F$2:$F$6,COUNTIF($F$2:$F$6,0)+3),$F$2:$F$6,0))

[Cutter]

I went with the helper column approach.

[martindwilson]

unique rank them then use small and countif
like this

[KeithMJ]

I took bits from each solution offered and it all works very nicely. Thank you, everyone.