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

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¤@­Óexcelªº¥¨¶°°ÝÃD

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¤@­Óexcelªº¥¨¶°°ÝÃD

¦pªG§Ú·Q­n§âC1ªº¤å¦r¡A½Æ»s¨ìA1¸òA2¡AC2ªº¤å¦r¡A½Æ»s¨ìA3¸òA4¡A¥H¦¹Ãþ±À¡A¦³¨S¦³¤ñ¸û²³æªº¤è¦¡°µ¡A¸ê®Æ¬ù¦³1¸Uµ§¡A§ä¤£¨ì§Ö³t¤è¦¡°µ¡A½Ð¦U¦ì¥ý¶i«ü¾É¡AÁÂÁ¡C

¦^´_ 1# spensers

A1=INDIRECT(ADDRESS(ROUNDUP(ROW(RC3)/2,0),3)) ¦V¤U©Ô

TOP

¦^´_ 1# spensers
A1=OFFSET($C$1,INT((ROW(A1)-1)/2),)
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¤G¦ì¥ý¶i¡A¤S¦h¾Ç¤F·sªºª¾ÃÑ¡A«D±`·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD