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

excel ¤G¶¥¿ï³æ°ÝÃD

excel ¤G¶¥¿ï³æ°ÝÃD

§Ú¦³¤@­Ó«~¦W¸ê®Æ Sheet3 ¦p¹Ï
[attach]12220[/attach]

¤@­Ó«~¦W+³W®æ¸ê®Æ Sheet4 ¦p¹Ï


§Ú³]©w¤@­Ó¦WºÙ¥i¥H¤U©Ô¡A¸ê®Æ½d³ò¬° Sheet3 ¸ê®Æ


½Ð°Ý²Ä¤G¼h¤U©Ô­n¨Ì§Ú¿ïªº«~¦W¡A°Ñ¦Ò Sheet4 §ì¥X
  ³W®æ ²£¥Í¤U©Ô­n¦p¦ó°µ©O??
  
  ½Ð¦U¦ì°ª¤â¤£§[«ü±Ð ÁÂÁÂ!!

¸É¤W Sheet3
Sheet3.JPG

¦A¸É¤W excel
®Æ¸¹1.rar (2.54 KB)

TOP

¦^´_ 2# hippoliao
¿ï¨úSheet1!B2
«Ø¥ß¦WºÙ³W®æ
°Ñ·Ó¨ì¤½¦¡
=OFFSET(Sheet4!$A$1,MATCH(Sheet1!$A2,Sheet4!$A:$A,0)-1,1,COUNTIF(Sheet4!$A:$A,Sheet1!$A2),)
Sheet1!BÄæÅçÃÒ
²M³æ¨Ó·½
=³W®æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ Hsieh ªº¸Ñµª...¥i¥H¤F

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD