D2=IF(B2<>"",SUMPRODUCT((LOOKUP(ROW($2:$16),ROW($2:$16)/(B$2:B$16<>""),B$2:B$16)=B2)*C$2:C$16),"")
F2{=INDEX(B:B,RIGHT(LARGE(IF(B$2:B$16<>"",D$2:D$16*10^9+ROW($2:$16)),ROW(A1)),9))
G2=INDEX(B:B,RIGHT(LARGE(MMULT(N(TRANSPOSE(LOOKUP(ROW($2:$16),ROW($2:$16)/(B$2:B$16<>""),B$2:B$16))=B$2:B$16),C$2:C$16)/1%+ROW($2:$16),ROW(A1)),2))
留言
張貼留言