直角三角型 二邊平方和=二數範圍最長邊平方 求二邊長 (13161)

C3:N6{=IFERROR(MID(RIGHT("000"&SMALL(IF(ISNUMBER(MATCH(ROW(INDIRECT(2&":"&$A3))^2+TRANSPOSE(ROW(INDIRECT(2&":"&$A3)))^2,ROW(INDIRECT($A3&":"&$B3))^2,))*(ROW(INDIRECT(2&":"&$A3))<TRANSPOSE(ROW(INDIRECT(2&":"&$A3)))),ROW(INDIRECT(2&":"&$A3))/1%%+TRANSPOSE(ROW(INDIRECT(2&":"&$A3)))),INT(COLUMN(B1)/2)),8),MOD(COLUMN(A1)-1,2)*4+1,4)*1,"")