202001211623排名前后3名 發扣奖励 (6509)

D4:D19{=SUM(FREQUENCY(C4,IF({1;0},SMALL(IF(MATCH(C$4:C$19,C$4:C$19,)=ROW($1:$16),C$4:C$19),{1,2,3}),LARGE(IF(MATCH(C$4:C$19,C$4:C$19,)=ROW($1:$16),C$4:C$19),{3,2,1})-1))*{3;2;1;0;-1;-2;-3})*1000*IFERROR(LOOKUP(B4,IF({1,0},B$2,B$1))=B$1,1)

前3名不考慮重複=SUM(FREQUENCY(C4,IF({1;0},{1,2,3},LARGE(IF(MATCH(C$4:C$19,C$4:C$19,)=ROW($1:$16),C$4:C$19),{3,2,1})-1))*{3;2;1;0;-1;-2;-3})*1000*IFERROR(LOOKUP(B4,IF({1,0},B$2,B$1))=B$1,1)

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





Powered by Xuite