字母所在儲存格名稱 (13733)

G2{=IFERROR(ADDRESS(INT(SMALL(IF(A$2:D$11=F$2,ROW($2:$11)/1%+{1,2,3,4}),ROW(A1))/100),RIGHT(SMALL(IF(A$2:D$11=F$2,ROW($2:$11)/1%+{1,2,3,4}),ROW(A1))),4),"")



留言