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

[µo°Ý] ¦p¦ó¦b¨C­ÓÄæ¦ì°Ñ·Ó¡A¨Ì©T¼Æ­È¼W¥[©O?

[µo°Ý] ¦p¦ó¦b¨C­ÓÄæ¦ì°Ñ·Ó¡A¨Ì©T¼Æ­È¼W¥[©O?

¥»©«³Ì«á¥Ñ WOW9637 ©ó 2016-1-18 13:58 ½s¿è

©êºp ¤£¤Ó·|ªí¹F¡A§Æ±æ¦p¤U¡G
A1 = B1
A2 = B11
A3 = B21
A4 = B31
.
.
½Ð°Ý³o¼Ë­n¦p¦ó»s§@©O¡A³Â·Ð¦U¦ìÅo¡C

A1 =INDIRECT("B"&(ROW(A1)-1)&1)
¤½¦¡©¹¤U½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# WOW9637

§A­nªº¶Ü¡H
¬¡­¶Ã¯1.rar (6.27 KB)

TOP

¦^´_ 2# ML089

ML089¤j¤j¡A¤£¦n·N«ä¡A§Ú­ì¥»¥H¬°À³¸Ó¬O¼Æ­È+-ªºÅܤÆ@@"

§Ú¹ê»Ú­nªº¬O¡G
I4 = C4          ¡FJ4 = F10
I5 = C39        ¡FJ4 = F45
I6 = C74        ¡FJ4 = F80
.
.

TOP

¦^´_ 3# tku0216


    tku0216¤j¤j¡A¤£¦n·N«ä¡A§Ú¥Ø«e¨S¿ìªk¤U¸ü¤å¥ó@@

TOP

¦^´_ 4# WOW9637

§Ú¹ê»Ú­nªº¬O¡G
I4 = C4          ¡FJ4 = F10
I5 = C39        ¡FJ4 = F45
I6 = C74        ¡FJ4 = F80


4¡B39¡B74 ¤Î10¡B45¡B80 ¬Oµ¥®t 35

I4 = INDIRECT("C" & ROW(A1)*35 - 31)
J4 = INDIRECT("F" & ROW(A1)*35 - 25)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


   ML089¤j¤j¡A«D±`·PÁ±zªºÀ°¦£¡A¬Ý¨Ó§Ú»Ý­n¦n¦n¬ã¨s°}¦C¤F@@

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD