隱藏行不計 累計起訖號 (14684)

日期：

F4=IF(E4="","",TEXT(SUBTOTAL(109,OFFSET(E$1,,,ROW(A1)))+1,"000")&IF(E4=1,"","-"&TEXT(SUBTOTAL(109,OFFSET(E$1,,,ROW(A4))),"000")))



留言

張貼留言