非空 依序二種取值 (14858)

日期：

E2{=IFERROR(RIGHT(SMALL(IF(B$2:C$9>0,{1,2}/1%%+ROW($2:$9)/1%+B$2:C$9),ROW(A1)),2)*1,"")

E2{=IFERROR(RIGHT(SMALL(IF(B$2:C$9>0,{1,2}/1%%+ROW($2:$9)/1%+B$2:C$9),ROW(A1)),2)*1,"")



留言

張貼留言