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

來源: 毛毛爸 於 2008-07-07 12:02:57 [] [舊帖] [給我悄悄話] 閱讀數 : (204 bytes)

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

請您先登陸，再發跟帖！