轉置 且非0取最低 (14141)

H2{=MIN(IF(OFFSET(A$2,,MAX(ROW(A1)),6),OFFSET(A$2,,ROW(A1),6)))

I2:N5=OFFSET($A$1,COLUMN(A1),ROW(A1))/$H2



留言