一列名称 一列數值 (10540)

 

 N1:W10{=IFERROR(INDIRECT(TEXT(RIGHT(LARGE(IF(($N$13:$W$20>=200)*($N$12:$W$12=$M1),$N$13:$W$20*10^6+ROW($13:$20)/1%+IF(MOD(COLUMN(A1),2),13,COLUMN($N:$W))),INT(COLUMN(B1)/2)),4),"!R0C00"),),"")