202205251000合併格計算人數與戶數 (10002)

H2:H22=IF(B2>0,-LOOKUP(9,-MATCH(1=1,B3:B$23<>"",{1,0}))&"人","")

I2:I22=IF(H2="","",COUNT(0/FREQUENCY(OFFSET(G2,,,LEFTB(H2,2)),OFFSET(G2,,,LEFTB(H2,2))))&"户")

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