201906011034連續空白與非空白 (5698)

I2:I13{=IF(COUNTIF(D2:H2,"<>")=0,"",TEXT(MIN(IF(D2:H2>0,("R"&D$1:H$1&"/1")*1)),"E年M月")&IF(COUNTIF(D2:H2,"<>")=1,"","~"&TEXT(MAX(IF(D2:H2>0,("R"&D$1:H$1&"/1")*1)),"E年M月")))

J2:J13{=IF(AND(D2:H2>0),"",INDEX(TEXT(("R"&D$1:H$1&"/1")*1,"E年M月"),MAX(IF(D2:H2>0,COLUMN(A:E)))+1)&IF(G2>0,"","~"&"108年5月"))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite