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

½Ð°Ý¦p¦ó¼g¤½¦¡©O? ³o­Ó¤u§@ªíŪ¨ú¥t¤@­Ó¤u§@ªí

½Ð°Ý¦p¦ó¼g¤½¦¡©O? ³o­Ó¤u§@ªíŪ¨ú¥t¤@­Ó¤u§@ªí

¤j®a¦n¡A

·Q½Ð±Ð¤@­Ó°ÝÃD¡G


¤u§@ªí1ªºA1«öµ¥©ó(=) ¤§«á¡A¥h¿ï¾Ü¤u§@ªí2ªºA1¡A³o®É·|¥X²{¡u=¤u§@ªí2!A1¡vªº¤½¦¡¡A¨Ã¥B­È·|Åã¥Ü¤u§@ªí2¸ÌªºA1­È(¦Û¤v³]©wªº­È¡G100)¡C(³o­Ó¬OEXCEL¹w³]ªº¥\¯à)

¦ý¦pªG·Q¦Û¤v¤â¼g¤½¦¡¡A­n¦p¦ó¼g¡A¤~¯à¦¨¥\Ū¨ú­È©O?
(§Ú¸ÕµÛ¦bA4¼g¡u=C4&"!A1"¡v¡A¦ý¥u·|¥X²{¡u¤u§@ªí2!A1¡v¡A¨Ã¤£·|Ū¨ú¨ì¤u§@ªí2ªºA1­È¡C)

¦A³Â·Ð¦U¦ì¤j¯«¨ó§U¡AÁÂÁ¤j®a¡C

ªþ¤Wªþ¥ó¡G ¬¡­¶Ã¯1.zip (7.36 KB)

¦^´_ 1# gaishutsusuru

=INDIRECT(C4&"!A1")

TOP

¦^´_ 2# jcchiang


  ¤Ó·PÁ±z¤F¡A¥i¥H¨Ï¥Î®@¡C:D

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD