項次找出多維資料 (11607)

C17:F21{=IFERROR(INDIRECT(TEXT(RIGHT(MAX(IF(($B$2:$V$2=$B$16)*($B$3:$V$12=$B17),ROW($3:$12)/1%+COLUMN(C:W)*10001)),4),"!R0C00"),)&"","")

固定十項往右建立=OFFSET($B$2,MOD($B17-1,10)+1,INT(($B17-1)/10)*5+COLUMN(A1))&""

G17:G21=E17*F17