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

[µo°Ý] Ãö©óÀx¦s®æÂà´«°ÝÃD

[µo°Ý] Ãö©óÀx¦s®æÂà´«°ÝÃD

¦U¦ì¤j¤j¡ã¡ã¡ã
¦b¤U¦³¨â­Ó°ÝÃD·Q½Ð°Ý
°ÝÃD1¡G

§Ú¦³¤@±iÂà´««eªºªí¡ã
·Q­nÅܦ¨Âà´««áªº®æ¦¡
À³¸Ó­n¦p¦ó°µ©O¡H¡H¡H

°ÝÃD2¡G

­YÀx¦s®æ¼Æ¥Ø¤£¤@¼Ë¡ã
­n¦p¦ó±N¸ê®ÆÂà¸m¨ì¦³¦X¨Ö¹LªºÀx¦s®æ¤º©O¡H¡H¡H

ÁÙÀµ½Ð¤j¤j­Ì¯à¨ó§U
·P¿E¤£ºÉ¡ã¡ã¡ã¡ã¡ã

111.JPG (20.08 KB)

111.JPG

¦^´_ 1# dodo234


(1)
C2 =OFFSET($A$2,ROW(A1)-1+COLUMN(A1)*4-4,)



(2)
D2 =OFFSET($A2,,(COLUMN(A1)-1)/2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
¸U¤À·PÁÂML089ª©¥D¨ó§U¡ã¡ã¡ã¡ã
³Ìªñ¤å¥ó­è¦n³£­n¥Î¨ì³o¨ÇÂà´«¡ã
²{¦bµÛ¹ê·|§Ö¤F¤£¤Ö¡ã¡ã¡ã

TOP

¦^´_ 2# ML089
ML089ª©¤j¡G
¤£¦n·N«ä­ù¡ã
Ãö©ó±zªº²Ä¤@­Ó¨ç¼Æºâ¦¡¡ã§ÚÁÙ¤£¤j·|À³¥Î»¡¡ã
¬ã¨s¤F«Ü¤[¡ã¬ã¨s¤£¥X¨Ó¡Ö¡@¡Õ
¦]¬°­Y§Ú·QÅܧó¤U¹Ïªº¸Ü
¤£ª¾­Y¥Î±zªº¨ç¼Æ­n«ç§ï©O¡H¡H¡H
¥¼©R¦W-.jpg
Àµ½Ðª©¤j¦A±Ð¤@¤U¡ã¡ã¡ã·P¿E¤£ºÉ¡ã¡ã¡ã

TOP

¦^´_ 4# dodo234

C2 =OFFSET($A$2,ROW(A1)-1+COLUMN(A1)*4-4,)
³o¬O4­Ó¤@²Õ

­Y­n§ï¬°5­Ó¤@²Õ
C2 =OFFSET($A$2,ROW(A1)-1+COLUMN(A1)*5-5,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089
®¦®¦¡ã¡ã¡ãÁA¸Ñ¤F¡ã¡ã¡ã¡ã·PÁª©¥D^O^

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD