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

[µo°Ý] «ç§â¤£¦P¤u§@ªíªº¬Û¦PÄæ¦ì¶°¤¤¨ì²Ä¤@±i¤u§@ªí¤W

[µo°Ý] «ç§â¤£¦P¤u§@ªíªº¬Û¦PÄæ¦ì¶°¤¤¨ì²Ä¤@±i¤u§@ªí¤W

½Ð°Ý°²¦p¦³10±i¤u§@ªí
­n«ç¼Ë¥Î¨ç¼Æ±N¨C±iªíªºB3Äæ¦ì
¨Ì·Ó¤u§@ªí¶¶§Ç³£§ì¨ì²Ä¤@±i¤u§@ªí£z
§äºô¸ô¦n¤[§ä¤£¨ì¥uª¾¹D¥Îindirect¨ç¼Æ

¦^´_ 9# Bodhidharma

©êºp¡AR(ow)©MC(olumn)ªº¦ì¸m¼g¤Ï¤F¡K
À³¸Ó¬O
  1. =INDIRECT("'Sheet"&ROW(1:1)&"'!R"&ROW($1:$1)+2&"C"&COLUMN(),FALSE)
½Æ»s¥N½X
¬O»¡ROW($1:$1)+2¸ò3¦³®t¶Ü¡H¨S¦³ªº¸Ü´Nª½±µ
  1. =INDIRECT("'Sheet"&ROW(1:1)&"'!R3C"&COLUMN(),FALSE)
½Æ»s¥N½X
´N¦n¤F

    ¦]¬°§Úºâ¥®¸X¶é¯Åªº©Ò¥H¾Çªº«ÜºC
·PÁ¦U¦ìªº¨ó§U

¦pªG¦³°ÝÃD¡AÁ¿²M·¡¬O­þ­Ó³¡¤À¦³°ÝÃD¡AÀ³¸Ó¥i¥H¾Ç±o¤ñ¸û§Ö
¤£¹L³o¦ê©M§A­ì¥»ªº°ÝÃD¤w¸g¦³ÂI»·¤F¡K(µÒ)

µM«á·Q½Ð°Ý¤@¤U­n«ç»ò¼Ë¤@¦¸¦^´_¨â­Ó¤H¡H

TOP

¦^´_ 9# Bodhidharma


    ¦]¬°§Úºâ¥®¸X¶é¯Åªº©Ò¥H¾Çªº«ÜºC
·PÁ¦U¦ìªº¨ó§U

TOP

¦^´_ 5# xu123
  1. =INDIRECT("'Sheet"&ROW(1:1)&"'!"&SUBSTITUTE(ADDRESS(ROW(),COLUMN(),4),ROW(),"")&ROW($1:$1)+2)
½Æ»s¥N½X
¨ä¹êINDIRECT¥i¥H¨Ï¥ÎR1C1ªº®æ¦¡¡A¤£»Ý­n³o»ò¨¯­W§ä¥Ø«eªºÄ檺¦W¦r
¦]¦¹¥i¥H§ï¬°
  1. =INDIRECT("'Sheet"&ROW(1:1)&"'!R"&COLUMN()&"C"&ROW($1:$1)+2,FALSE)
½Æ»s¥N½X
§Y¥i

°Ñ¦Ò
http://isvincent.pixnet.net/blog/post/33373904-excel-%E5%85%AC%E5%BC%8F%E4%B8%AD%E4%BD%BF%E7%94%A8r1c1-%E4%BD%8D%E5%9D%80%E5%8F%83%E7%85%A7%E6%A8%A3%E5%BC%8F

TOP

¦^´_ 7# Bodhidharma


    Bodhidharma¤j¤j
¥i¥H¨Ï¥Î
³Â·Ð§A¤F

·PÁÂ

TOP

¦^´_ 5# xu123

°²³]­n·j´Mªº¤é´Á©ñC1
  1. =VLOOKUP($C$1,INDIRECT("Sheet"&ROW(A1)&"!A:B"),2)
½Æ»s¥N½X
¤U©Ô

TOP

p212¤j
§Aªº¤è¦¡¹ï§Ú¦Ó¨¥
¦³ÂIÃø

TOP

¥i¥H¦A°Ý¤@¤U¶Ü
¨º°²¦p
­nªº¸ê®Æ¤£¦b¦P¤@­ÓÄæ¦ì
¨Ò¦p
¨C­Ó¤u§@ªíA¦C³£¦³¤é´Á0421¬Û¹ïÀ³ªºB¦CÄæ¦ì«ç§ì¨ì²Ä¤@­Ó¤u§@ªí
¨Ò¦pªí2 A5¤é´Á¬°4¤ë21¤é¨ºB5´N¬O§Ú­nªº¸ê®Æ
        ªí3 A6¤é´Á¬°4¤ë21¤é¨ºB6´N¬O§Ú­nªº¸ê®Æ
        ¤@ª½¨ìªí10
        «ç§â¥¦­Ì³£§ì¨ìªí¤@
·PÁÂ

TOP

¦^´_ 1# xu123
´£¨Ñ¥t¤@­Ó«ä¦Ò¤è¦¡¡A½Ð°Ñ¦Ò¡I
°²³]¤u§@ªí¦WºÙ¬°Sheet1,Sheet2,Sheet3,...
¦b¸ÓÀɤº¶}¤@­Ó·s¤u§@ªí
½Ð¦bB1Àx¦s®æ¿é¤J
=INDIRECT("'Sheet"&ROW(1:1)&"'!"&SUBSTITUTE(ADDRESS(ROW(),COLUMN(),4),ROW(),"")&ROW($1:$1)+2)
¨ä¤¤¡A¥HSUBSTITUTE(ADDRESS(ROW(),COLUMN(),4),ROW(),"")¨ú±o¨ç¼Æ©Ò¦bÀx¦s®æ¦ì§}¤§¡uÄæ¦W¡v¥H¦r¥À¼Ð¥Ü
¦p¦¹¥i¦V¥k½Æ»s¤½¦¡ÂX®i¨ú¥X¤£¦P¤u§@ªí¹ïÀ³ªºÄæ¦ì¸ê®Æ(CÄæ¡BDÄæ¡B...)

TOP

¦^´_ 2# Bodhidharma


   ·PÁ Bodhidharma¤jªº¦^´_
¥i¥H¨Ï¥Î
«D±`·PÁÂ
:D

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD