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

excel¦Û°Ê±a¤J«ü©w§@·~°Ïªº­È

excel¦Û°Ê±a¤J«ü©w§@·~°Ïªº­È

¦³¤°»ò¤è¦¡¥i¥HÅýexcel¦Û°Ê±a¤J©Ò«ü©w¥t¤@¬¡­¶ªº¯S©w­È
¦p¹Ï¡G
sheet2 ¬°§@·~°Ï


·ísheet2ªºE¤ÎF¦³¼Æ­È®É
sheet1 ¦Û°Ê±a¤J©Ò«ü©wªº¸ê®Æ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-4-13 13:22 ½s¿è

¦^´_ 1# joyce9999


    ¦P¦C¦³²{ª÷¤]¦³¤ä²¼ªº°µªk?
¦¬¤äï.zip (7.38 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¤Ñ¤~¦Ñ®v~~¦Ñ®v
    ¦¹ÀɮתºSHEET1 ²ÄG H ¦C¤¤ªº³]©w~~~ §Ú¤]­n³]©w¶i¥h¶Ü?

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-4-12 23:32 ½s¿è

¦^´_ 3# joyce9999
¨º2Äæ¬O§ÚÅçºâ®É¯d¤Uªº¡A§â¥L­Ì§R°£§Y¥i
¼Ó¤WÀɮפw§ó·s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ¥u­n§R°£´N¦n¶Ü? ÁÙ¬O¦³­×§ï¨ä¥Lªº¦a¤è¡ã¡ã¡@¦]¬°¤p¾Ç¥Í¤£¯à¤U¸ü :'(

TOP

¦^´_ 4# Hsieh
½Ð°ÝH¤j¥i¥H¸ÑÄÀ¦WºÙ©w¸q¤¤ªº¦U­Ó³]©w¶Ü?¤×¨ä¬O¨º­Óar,·Q¤£³q¨ä·N¸q©Ò¦b
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# FAlonso

¾ã­ÓÅÞ¿è¦p¤U
x=COUNTA(Sheet1!$A:$A)    ­pºâSheet1!AÄæ¸ê®Æ¶q
a=OFFSET(Sheet1!$E$1,1,,x,2)  ¶Ç¦^Sheet1!E:FÄæ½d³ò
b=OFFSET(Sheet1!$A$1,1,,x,2)  ¶Ç¦^Sheet1!A:BÄæ½d³ò
ar=IF(a<>0,ROW(b)*10+COLUMN(b),"")  E:F½d³ò¦³¼Æ­È´N¶Ç¦^¸ÓÀx¦s®æ¦C¦ì*10¥[¤W¦WºÙb½d³òªºÄæ¦ì¹ïÀ³­È
¦]¬°­n¨úE:F¤GÄæ¹ïÀ³Äæ¦ì¡A©Ò¥H¥ÎA:BªºÄæ¦ì¡A·|¬O1¡A2ªº²Õ¦X
¦p¦¹¤@¨Ó¦C¦ì*10+Äæ¦ì(1©Î2)´N·|¦³¤£¦P¤j¤pªº­È¥X²{
y=INT(SMALL(ar,ROW(Sheet2!$A1))/10) ­pºâ¥X¦C¦ì
z=SMALL(ar,ROW(Sheet2!$A1))-y*10   §â¦C¦ì´î¥hªº¾l¼Æ´N¬OÄæ¦ì(«D1§Y2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD