出現次序 找儲存格名稱 (14932)

I2{=ADDRESS(MOD(SMALL(IF(B$2:E$16=G2,ROW($2:$16)+{2,3,4,5}/1%),H2),100),INT(SMALL(IF(B$2:E$16=G2,ROW($2:$16)+{2,3,4,5}/1%),H2)%),4)

J2{=ADDRESS(INT(SMALL(IF(B$2:E$16=G2,ROW($2:$16)/1%+{2,3,4,5}),H2)%),MOD(SMALL(IF(B$2:E$16=G2,ROW($2:$16)/1%+{2,3,4,5}),H2),100),4)



留言