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

[µo°Ý] ½Ð±Ð°ª¤â...excel¦³¿ìªk°µ¨ì¡A¦Û°Ê¡u·s¼W¡v¡u­×§ï¡v¡u§R°£¡v¶Ü??

¦^´_ 9# Iuy762102896

¥²¶·¨Ï¥Î°}¦C¤½¦¡
¿é¤J¤½¦¡«á¥Hctrl+shift+enter§¹¦¨¿é¤J
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# Hsieh

§Ú¥Îctrl+shift+enter¡A¥i¥H¦¨¥\ªº§â¥Àªí³æªº¸ê®Æ¦Û°Ê·s¼W¨ì¤lªí³æ¤F¡AÁÂÁÂ
¤£¹L³o­Ó¡uctrl+shift+enter¡v¬O¥Nªí¤°»ò§r?!¬°¤°»ò§Ú¤@¶}©l¥Î½Æ»sªº³£·|¥X²{¿ù»~??
¥t¥~¡A§ÚÁöµM¥i¥H§â¥Àªí³æªºªF¦è·s¼W¨ì¤lªí³æ¡A¦ý¬O§Ú¦b¥Àªí³æ¦h¼W¥[¤F¤@¦æ¸ß»ù¡A¸ß»ù¨ºÃä¨S¦³·s¼W¤W¥h®º...
¬O§Ú¾Þ§@¦³°ÝÃD¶Ü@@?
½Ð¤j¤jÀ°§Ú¸Ñ°£ºÃ°Ý¡A·PÁÂ~~

TOP

¦^´_ 12# Iuy762102896


    ¦]À³¸ê®Æ¼W¥[¥²¶·¨Ï¥ÎÅܰʽd³ò
·s¼W¤@­Ó©w¸q¦WºÙ
ng°Ñ·Ó¨ì¤½¦¡=OFFSET(¸ê®Æ!$D$1,,,COUNTA(¸ê®Æ!$D:$D)-1,)
¦U¤À­¶A2°}¦C¤½¦¡
=IF(COUNTIF(rng,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))+1=ROW($A1),"¥H¤UªÅ¥Õ",IF(COUNTIF(rng,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))<ROW($A1),"",OFFSET(¸ê®Æ!$A$1,SMALL(IF(rng=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2),ROW($2:$5),""),ROW($A1))-1,COLUMN()-1)))
¦V¤U¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  Iuy762102896


    ¦]À³¸ê®Æ¼W¥[¥²¶·¨Ï¥ÎÅܰʽd³ò
·s¼W¤@­Ó©w¸q¦WºÙ
ng°Ñ·Ó¨ì¤½¦¡=OFFSET(¸ê®Æ ...
Hsieh µoªí©ó 2012-11-27 13:29


...¤j¤j§Ú¦³§xÃø...
¡ung°Ñ·Ó¨ì¤½¦¡=OFFSET(¸ê®Æ!$D$1,,,COUNTA(¸ê®Æ!$D:$D)-1,)¡v
ng¬OÔ£...¤½¦¡§Ú­n©ñ¨ì­þÃä¥h...

TOP

©w义1个·s¦W称参·Ó¦Ó¤w¡A¦b©w义¦W称对话®Ø¤¤¶ñ写¦p¤U¡G
Name : ng
Refers to: =OFFSET(¸ê®Æ!$D$1,,,COUNTA(¸ê®Æ!$D:$D)-1,)
¥u¦³·Q¤£¨ìªº,
没¦³°µ¤£¨ìªº.

TOP

¦^´_ 9# Iuy762102896

°}¦C¤½¦¡
¤½¦¡¿é¤J§¹­n«ö CTRL+SHIFT+ENTER
kuoliang

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD