N3:P17{=OFFSET($A$1,SMALL(IF(($C$1:$K$1=MID($Q$1,3,2))*($R$1=$C$2:$K$18),ROW($1:$17),99),ROW(A1)),MAX(($C$2:$K$18=$R$1)*COLUMN($B:$J)*(B$2<>$B$2)+COLUMN(A1)-1))&""
P18{=SUM(IFERROR(O3:O17*P3:P17,))
Q3:Q17{=IF(N3="","",TEXT(MAX((A$2:A$18=N3)*(C$2:I$18<R$1)*(C$1:I$1=C$1)*C$2:I$18),"M/D;;"))
留言
張貼留言