ªð¦^¦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¨ç¼Æ

¦^´_ 1# xu123

°²³]¤u§@ªí¦WºÙ¤À§O¬°Sheet1,Sheet2...Sheet10
¨º´N¥i¥H¥Î
  1. =INDIRECT("Sheet"&ROW(A1)&"!B3")
½Æ»s¥N½X
¤U©Ô

TOP

¦^´_ 2# Bodhidharma


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

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

¥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

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

TOP

¦^´_ 5# xu123

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

TOP

¦^´_ 7# Bodhidharma


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

·PÁÂ

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

¦^´_ 9# Bodhidharma


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

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD