依運算公式 相加後排序 (13501)

G3{=INDEX(A:A,RIGHT(LARGE(INT((100+(C$3:C$16-B$3:B$16)/B$3:B$16+(D$3:D$16-C$3:C$16)/C$3:C$16)/1%%)/1%+ROW($3:$16),ROW(A1)),2))

另解{=INDEX(A:A,RIGHT(LARGE(INT((100+MMULT((C$3:D$16-B$3:C$16)/B$3:C$16,{1;1}))/1%%)/1%+ROW($3:$16),ROW(A1)),2))



留言