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

½Ð°Ý¸ê®ÆÅçÃÒ2..

½Ð°Ý¸ê®ÆÅçÃÒ2..

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2010-6-19 21:59): ½Ð¤W¶ÇÀÉ®×

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-6-19 21:58 ½s¿è

½Ð°Ý¸ê®ÆÅçÃÒ°ÝÃD..
B3§Ú¥Î´¡¤J-¦WºÙ..©w¸q..·s¼W¤@­Ó«~¦W..   =Sheet2!$B$2:$B$38
C3§Ú¥Î´¡¤J-¦WºÙ..©w¸q..·s¼W¤@­Óµ¥¯Å..   =Sheet2!?????????
½Ð°ÝC3§Ú¸ê®ÆÅçÃÒ­n¦p¦ó¥Î¤~¯à§ÚÂIB3¿ïA®É§Ú¥i¥H¿ïSheet2ªºC2:C30
¦ÓB3§Ú§ïÂI¿ïB®É·|¦Û°Ê¬Û¹ïÀ³Åý§Ú¿ïSheet2ªºD2:D30
½Ð¦U¦ìª©¤j«üÂI..
ÁÂÁÂ

¦^´_ 1# steven


    ¸Õ¸Õ¬Ý

ÅçÃÒ.rar (2.31 KB)

TOP

·PÁ¤j¤j«ü¾É
¤£ª¾¥i§iª¾¤èªk§ÚÁÙµLªk¤U¸üªþ¥ó
ÁÂÁ¤j¤j...

TOP

¦^´_ 3# steven
1©w¸q..·s¼W¤@¦WºÙ..   «~¦W=Sheet2!$B$2:$B$38   ¨Ò¤º®e¬°:  AA,BB,CC,,,,
B3 ÅçÃÒ²M³æ ¦p¹Ï1




2©w¸q..·s¼W¤@¦WºÙ    µ¥¯Å..   ???=Sheet2!?????????
           ¨Ò: AA=Sheet2!$C$2:$C$10
                BB=Sheet2!$D$2:$D$10
                CC=Sheet2!$E$2:$E$10 ,,,,,         
C3  ¥Î INDIRECT ¨ç¼Æ ¶Ç¦^  B3­Èªº¦WºÙ½d³ò °µ¬° ÅçÃÒªº²M³æ
¦p¹Ï2

TOP

ÁÂÁ¤j¤j¨¯­W±Ð¾Ç
¤p§Ì¨ü±Ð..·P®¦«ü¾É..
©|¦³¤@¨Æ½Ð±Ð
¦¹¤è¦¡¥i¼g¤JVBA¤¤¶Ü...

TOP

¦^´_ 4# GBKEE


    µ¥¯ÅÅçÃÒ²M³æ©w¸q¦WºÙx¤½¦¡=OFFSET(Sheet2!$B$2,,MATCH(Sheet1!$B$1,«~¦W,0)+1,11,)
¥t¼Ó¥D·Q¥Îvba§¹¦¨·íµM¤]¬O¥i¦æ
¤£¹Lvba­n«ü©wÀx¦s®æ¨Ï¥Î
¥Î°_¨Ó¤Ï¦Ó¤£¤è«K
­Y¯u­n¼g§A´N¤W¶ÇÀɮ׬ݬݹï·Ó®æ¦¡¦A¨Óª±ª±
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ¦p½d¨Ò¤¤½Ð«ü¾ÉÁÂÁª©¤j«ü¾É

A.rar (2.1 KB)

TOP


bÄæÅçÃÒ¤½¦¡=y
cÄæÅçÃÒ¤½¦¡=x
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ª©¤j§A¦n§Ú¸Õ¹L¦ýCÄæÅçÃÒ·|¥X²{¨Ó·½ªºÂ¾±N·|¾É¨î¿ù»~
°ÝÃD¥X²{¦b­þ¸Ì..
½Ð«ü¾ÉÁÂÁÂ..

TOP

¦^´_ 9# steven


    ª©¤j¦w¦n¬°¦ó¥u¦³C2¯à¥¿½T¬D¿ï
¦ÓC3¥H«á«oµLªk¥¿½T¬D¿ï¦pªþ¥óA1

A1.rar (2.3 KB)

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD