N2{=INDEX(B:B,RIGHT(LARGE(MMULT(FIND($C$2:$L$16,"EDCBA"),ROW(1:10)^0)/1%+ROW($2:$16),ROW(A1)),2))
O2=SUMPRODUCT(FIND(C$2:L$16,"EDCBA")*(B$2:B$16=N2))
T2{=INDEX(B:B,RIGHT(LARGE(MMULT(VLOOKUP(T(IF({1},$C$2:$L$16)),Q:R,2,),ROW(1:10)^0)/1%+ROW($2:$16),ROW(A1)),2))
U2=SUMPRODUCT(LOOKUP(C$2:L$16,Q:Q,R:R)*(B$2:B$16=T2))
留言
張貼留言