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

¤G¼h¤U©Ô¿ï³æ¹J§xÃø

¤G¼h¤U©Ô¿ï³æ¹J§xÃø

¦pªþÀÉ¡A§Ú¦b¸ê®Æ1¤¤¥ô·NÀx¦s®æ©w¸q¡u²Ä¤@¼h¡v¡A¦bB2Àx¦s®æ©w¸q¡ubut¡v¤Î¡u²Ä¤G¼h¡v
¥t¦b¿é¤J¤¤A2Àx¦s®æ³]©wÅçÃÒ¤U©Ô²M³æ¡A¸ê®Æ¨Ó·½¡u=²Ä¤@¼h¡v¡A¥i¬O¦bB2Àx¦s®æ³]©w¤U©Ô²M³æ¡A¸ê®Æ¨Ó·½¡u=²Ä¤G¼h¡v¡A¤@ª½µLªk³]©w¡A³£»¡¨Ó·½­È¦³°ÝÃD¡A¤£ª¾¬O¦ó¦]¡H
§Ú§@³o­ÓÀɪº¥Øªº¡A¬O·í§Ú¦b¿é¤J¤¤A2Àx¦s®æ¤¤¥Î¤U©Ô²M³æ¿ï¥X¬ì§O«á¡A¦bB2Àx¦s®æ·|±a¥X¦b¸ê®Æ1¤¤¸Ó¬ì§O¤Uªº¦Ñ®vÅý§Ú¿ï¾Ü¡C

¤G¼h¤U©Ô.zip (1.74 KB)

­×¥¿
²Ä¤G¼h=OFFSET(but,,,,COUNTA(OFFSET(but,,,,255)))

but<>buf
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

ÁÂÁ´£¨Ñ¡A­ì¨Ó¬O¦h¤G²Õ¤W¼Ð¡I

TOP

¬O¶Ü!
§Úªº·N«ä¬O¦WºÙ«÷¿ù
À³¸Ó¬Obut,¦ý§Aªº©w¸q¦WºÙ¤ºÁ䬰buf
§ï¥¿«á§Y¥i

but<>buf
ªí¥Übut¤£µ¥©óbuf
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

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