找字母行列號 (10558)


G2:H9=MID(SUMPRODUCT(($B$2:$D$9=$F2)*(ROW($2:$9)&{2,3,4})),COLUMN(A1),1)


行列號2位數=MID(TEXT(SUMPRODUCT(($B$2:$D$9=$F2)*(ROW($2:$9)/1%+{2,3,4})),"0000"),COLUMN(A1)*2-1,2)*1


I2:I9=INDIRECT(ADDRESS(G2,H2,4))


留言