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

¸ó¤u§@ªí¦p¦ó³]©w¸ê®ÆÅçÃÒ

¸ó¤u§@ªí¦p¦ó³]©w¸ê®ÆÅçÃÒ

½Ð±Ð°ª¤â

½Ð°Ý
¦pªG·Q­n¸ó¤u§@ªí¨Ï¥Î²M³æ¨Ó§@¸ê®ÆÅçÃÒ
­n¦p¦ó³]©w©O
¨Ò¦p
§Ú­n¨Ï¥Îsheet2  A1:A10 ªº¸ê®Æ²M³æ¨ÓÅçÃÒ ¦bsheet1  A1ªºÀx¦s®æ
­n¦p¦ó³]©w

ÁÂÁÂ
~~

½Ð°Ý¬O  ¦b sheet1  A1ªºÀx¦s®æ  ¥ÎÅçÃÒ¥\¯à¤¤ªº  ²M³æ¥\¯à¶Ü(²M³æ¤º®e¬°sheet2  A1:A10 )
¬O¾Çµ{¦¡¦Ó¤£¬O­nµ{¦¡¡A¬O¶i¨Bªº°ò¦

TOP

sheet2  A1:A10  ¡AÀx¦s®æ¿ï¨ú¡AµM«á  ´¡¤J>>¦WºÙ>> ©w¸q>>  
   ²{¦b¦WºÙ¡Gqq   (¥i¦Û¦æ³]©w)
   °Ñ·Ó¨ì(R)¡G=Sheet2!$A$1A$10(EXCEL¤w¦Û°Ê±a¤J)
sheet1  A1ªºÀx¦s®æ¡G¸ê®Æ>>Åçµý>>³]©w
  Àx¦s®æ¤º¤¹³\(A)¡G²M³æ  (¤U©Ô¿ï¾Ü)
  ¨Ó·½(S)¡G =QQ  (¿é¤J­è­è³]©wªº¦WºÙ)
«ö½T©w
¬O¾Çµ{¦¡¦Ó¤£¬O­nµ{¦¡¡A¬O¶i¨Bªº°ò¦

TOP

¦^´_ 3# ·t¶Â


ÁÂÁÂ
§Ú·Ó¤W­±ªº¨BÆJ³]©w
¥i¬O¤U©Ô²M³æ«o¥u¥X²{©w¸qªº¦WºÙ(qq)
¬O¨º­Ó¨BÆJ¥X¿ù©O?
~~

TOP

³Ì«á¤@­Ó¨BÆJ¡u¨Ó·½ =qq¡v¡A"="­n¥´¤W¥h¡A¦pªG¥u¥´qq¤£¦æ

TOP

½Ð°Ñ¾\½d¥»ÀÉ®×, ¤u§@ªí1¤Î2¦³©ú²Ó»¡©ú
Book1.rar (2.17 KB)

TOP

¦^´_ 6# 317

·PÁÂ
¥i¬O§Úµ¥¯Å¤£°÷
ÀɮפU¸ü¤£¤F
>_<
~~

TOP

¦^´_ 5# ÖqÖq


¥i¥H¤F­C
­ì¨Ó§Ú¤Ö¥´¤F"="
·PÁ¦U¦ì«e½úªº«ü¾É
~~

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD