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

[µo°Ý] ¤£¦Psheet¶¡Äæ¦ìªºÂà´«

[µo°Ý] ¤£¦Psheet¶¡Äæ¦ìªºÂà´«

¨Ò¦p
sheet 1ªº¤é´Á¬° B1,C1,D1
·Q­nª½±µµ¥©ósheet2 ªº A2,A3,A4
·í§Ú¿é¤J¦bsheet2ªºA2¬° "=Sheet1!C1"
µM«á©¹¤U©Ô®æ¦¡,µ²ªGA3Åܦ¨ "=Sheet1!C2"
©Ò¥H§Ú§ïA3¬° "=Sheet1!C$1"
¦ý¥LªºC¤£·|Åܦ¨D,¥i¥H½Ð±Ð¦³Ô£¿ìªk¨Ï¨ä§ïÅܶÜ,3Q
ªþ¤W¹Ï¤ù¥H¨Ñ°Ñ¦Ò
sheet1.png
2010-6-23 16:50

sheet2.png
2010-6-23 16:50

sheet2!A2=OFFSET(Sheet1!$B$1,,ROW(A2))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


·PÁ¶W¯Åª©¥D!!
«ü¥O¤£¬O«Ü©ú¥Õ
¤£¹Lµy·L§ï¤@¤U¤º®eA2¤~¥¿½T¥X²{¸ê®Æ
answer.png
2010-6-23 20:01

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD