=MIN(IF((E1:E60>0)*(A1:A60),(A1:A60)))

来源: 于 2008-07-07 12:02:57 [旧帖] [给我悄悄话] 本文已被阅读：次

assuming your data range is 1:60, enter the formula in F1
then find/match F1 in B column

note: The formula is an Array Formula, after entering the formula in the cell, press Ctrl+Shift+Enter