最大與最小 姓名與年份 (14336)

K3:K11{=SUBSTITUTE(IF(-1^(ROW(A1)>COUNT(0/(MAX(B$3:I$7)=B$3:I$7)))+1,"Max","Min"),LOOKUP(1,0/(K$2:K2<>""),K$2:K2),"")

L3:M11{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(1-ISNA(MATCH($B$3:$I$7,PERCENTILE($C$3:$I$7,{0,1}),)),(100-$B$3:$I$7)*10^6+ROW(3:7)*10^5+(ROW($2:$6)^($K$2=K$2)+1)/1%+COLUMN($B:$I)^(K$2=$L$2)),ROW(A1)),4),"!R0C00"),),"")



留言