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

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

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

§Ú­n¦bExcelµe­Ü®wªºÀx¦ìªí¡A²M·¡°O¿ý¨C¤@­Ó­ìª«®Æ¦s©ñªº¦ì¸m¡C
¦bªþ¥ó( Book1.rar (3.89 KB) )¤¤§Ú­n¦p¦ó§Ö³t¶ñº¡ªÅ®æ³¡¥÷ªºÀx¦ì©O?

Book1.rar (3.89 KB)

¦^´_ 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

¥»©«³Ì«á¥Ñ infoverdad ©ó 2011-8-8 20:40 ½s¿è

¦^´_ 1# j2888237


    ²z¸Ñ¦U¸ê®Æ®æªº¹ïÀ³Ãö«Y²z¥X¤U¦C¤½¦¡:
=IF(or(MOD(COLUMN(),3)=0,row()>=A$18),"",TEXT(COLUMN()-INT(COLUMN()/3),"0")&"-"&TEXT((A$18-ROW())/2,"00")&"-0")  <= A2ªº¤½¦¡

¿ï¾Ü­n¶ñ¤J¤½¦¡ªº½d³ò, µ½¥ÎF5 => ¯S®í => ªÅ®æ ¤@¦¸±N¤W¦C¤½¦¡¶ñ¤J¹ïÀ³¦ì¸m¦p¹Ï warehouse.gif

¥tªþ¤WÀÉ®× warehouse.rar (4.77 KB)

Snap1.jpg (30.71 KB)

Snap1.jpg

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD