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

[µo°Ý] ·j´M¯S©wªº¦PÄæ¹ïÀ³­È¡C

[µo°Ý] ·j´M¯S©wªº¦PÄæ¹ïÀ³­È¡C

¥¼©R¦W.png
2019-12-13 15:16

´ú¸Õªþ¥óÀÉ¡J ·j´M¯S©wªº¦PÄæ¹ïÀ³­È¡C.rar (4.83 KB)

³Æµù¡J
BM3=(BB3¡ABB10¡ABB17¡ABB24¡ABB31¡ABB38¡ABB45¡ABB52¡ABB59¡ABB66µ¥¨C¸õ7¦Cªº10­ÓÀx¦s®æ)ªº³Ì¤j¼Æ¡C
BN3=(BC3¡ABC10¡ABC17¡ABC24¡ABC31¡ABC38¡ABC45¡ABC52¡ABC59¡ABC66µ¥¨C¸õ7¦Cªº10­ÓÀx¦s®æ)ªº³Ì¤j¼Æ¡C
¨ä¾lBO3¡JBV3Ãþ±À¡C

»Ý¨D¡J
BM4= BM3³Ì¤j¼Æªº¤U1¦C¦PÄæÀx¦s®æ¼Æ­È¡A
¦pªG¤U1¦C¦PÄæÀx¦s®æ¦³2­Ó(§t)¥H¤W©Î¦³­«½Æªº¼Æ­È¡A³£¨Ì§Ç©¹¤U¶ñ¤J~¹w©Ô¨ìBM13(µL¶ñ¤J­ÈªºÀx¦s®æ¡AÅã¥ÜªÅ¥Õ)¡C

BN4= BN3³Ì¤j¼Æªº¤U1¦C¦PÄæÀx¦s®æ¼Æ­È¡A
¦pªG¤U1¦C¦PÄæÀx¦s®æ¦³2­Ó(§t)¥H¤W©Î¦³­«½Æªº¼Æ­È¡A³£¨Ì§Ç©¹¤U¶ñ¤J~¹w©Ô¨ìBN13(µL¶ñ¤J­ÈªºÀx¦s®æ¡AÅã¥ÜªÅ¥Õ)¡C

¨ä¾lBO4¡JBV13Ãþ±À¡C

½Ð°Ý¡JBM4¡JBV13»Ý¨DªºExcel 2003ª©ªº¨ç¼Æ¤½¦¡¡H
·Ð½Ð¦U¦ì¤j¤jÀ°¦£¡IÁÂÁ¡I

BM4//°}¦C¤½¦¡:
=RIGHT(SUBSTITUTE(SMALL(--TEXT(IF(($BA$4:$BA$71="³Ì¤j")*(BB$3:BB$70=BM$3),0&MID(BB$4:BB$71,{1,4,7,10},2),0),"[=]!9!e9;"&ROW($103:$170)/1%),ROW(A1)),--"9E9",),2)

TOP

¦^´_ 2# ­ã´£³¡ªL
­ã´£ª©¥D :
ÁÂÁ±zªº¼ö¤ß«ü¾É©MÀ°¦£!
·P®¦

TOP

·PÁª©¥Dªºµo°Ý©M¦U¦ìª©¤jªº¸gÅç¤À¨É¡A§Ú¤]¥¿¦n¦³³o°ÝÃD­è¦n¥i¥H¸Õ¸Õ

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD