E3:E18{=IFERROR(LOOKUP(1,0/(SMALL(IF(MMULT(N(ISERR(-$A$3:$B$24)),{1;1}),ROW($3:$24)),ROW(A1))>=IF(1-ISERR(0/A$3:A$24),ROW($3:$24))),A$3:A$24),"")
F3:G18{=IF($E3="","",LOOKUP(IF(F$2=$F$2,"z",9^9),OFFSET(A$1:B$1,MAX(SMALL(IF(MMULT(N(ISERR(-$A$3:$B$24)),{1;1}),ROW($2:$23)),ROW(A1))),)))
留言
張貼留言