ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

ªÅ¥ÕªºÀx¦s®æ¦p¦ó¶ñº¡?!

¦^´_ 1# j2888237


    aaa.zip (5.51 KB)
a2=IF(AND(MOD(COLUMN(),3),LEN(A3)>1),col&"-0"&(ro+1-(ROW(A1)+1)/2)&"-0","")
©w¸q¤½¦¡
col=MOD(COLUMN(),3)+LOOKUP(COLUMN(),{1,4,7},{0,2,4})*(MOD(COLUMN(),3)<>0)
ro=SUM(MOD(ROW(Sheet1!A$3:A$13),2)*(LEN(Sheet1!A$3:A$13)>1))
»Ý±Ò°Ê¤ÏÂйBºâ

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD