202210051455平均值 最后幾个数据 (10578)

E3{=AVERAGE(IFERROR(RIGHT(LARGE(IF(A$2:A$15=D3,ROW(2:15)/1%+B$2:B$15),ROW(INDIRECT("1:"&G$3))),2)*1,""))

扣除 B列0{=AVERAGE(IFERROR(INDEX(B:B,N(IF({1},LARGE(IF((A$2:A$15=D3)*(B$2:B$15>0),ROW($2:$15)),ROW(INDIRECT("1:"&G$3)))))),""))

扣除 B列0{=AVERAGE(IFERROR(RIGHT(LARGE(IF((A$2:A$15=D3)*(B$2:B$15>0),ROW(2:15)/1%+B$2:B$15),ROW(INDIRECT("1:"&G$3))),2)*1,""))

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