分数最高與低的学科 (8877)

日期：


L2:N16{=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($1:$1,SMALL(IF($B2:$J2=MAX($B2:$J2),COLUMN($B:$J)),COLUMN(A1)))&M2,"")


P2:R16{=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($1:$1,SMALL(IF($B2:$J2=MIN($B2:$J2),COLUMN($B:$J)),COLUMN(A1)))&Q2,"")


留言

張貼留言