排序 圓圈裡數字 (10995)


E3:N5=MID($C3,COLUMN(A1),1)


E8:N10{=IFERROR(INDEX(3:3,RIGHT(LARGE(IF($E3:$M3<>"",COUNTIF($E3:$M3,">"&$E3:$M3)/1%+COLUMN($E:$M)),COLUMN(A1)),2)),"")


留言