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

[µo°Ý] ¤U©Ô¤½¦¡³]©w

[µo°Ý] ¤U©Ô¤½¦¡³]©w

½Ð°Ý¦U¦ì¤j¤j¡A§Ú­nÂ^¨ú1~31¤À­¶¸ê®Æªí¤¤Z13©MZ40Àx¦s®æªº¼Æ¦r¦b¥t¥~ªº¸ê®Æªí¤¤¹Bºâ
¥i¬O§Ú¿é¤J§¹²Ä¤@®æ­n¤U©Ô«á¡Aµo²{¸ê®Æªí³£¤£·|ÅÜ(+1)¡A¥u·|Åܧګ᭱ªºÀx¦s®æ
¦³¬Æ»ò¤è¦¡¤U©Ô®æ¦¡¥i¥H¥uÅܸê®Æªí¼Æ­È¦Ó¨ä¥L¤½¦¡¤£°Ê©O?(¦p¤U¤è¨Ò¤l)

¨Ò:
A1¤½¦¡¡G'1'!Z13+'1'!Z40

¡õ¤U©Ô¤½¦¡¡õ
A2¤½¦¡:  '2'!Z13+'1'!Z40
A3¤½¦¡:  '3'!Z13+'1'!Z40
A4¤½¦¡:  '4'!Z13+'1'!Z40
¤£·|EXCALLªº²Â³J

¦^´_ 1# prince0413

A1 =INDIRECT(ROW(A1)&"!Z13")+INDIRECT(ROW(A1)&"!Z40")
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

·PÁ¤j¤j

ÁÂÁ±zªº¦A¦¸À°§U
¤£·|EXCALLªº²Â³J

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD