- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
¥H¤U¬O§Ú·Q¨ìªº¤è¦¡¤ñ¸ûª½Ä±¤@¨Ç¨Ñ§A°Ñ¦Ò :
1. ¥ý¦b¨C¤@®æ«e±·s¼W¤@ªÅ¥ÕÄæ(¨Ò¦p "A"¡B"E" ...Äæ),°µ¬°¯Á¤ÞÈ¥H§ä¥X¨C¤@µ§n¨qªº¸ê®Æ.
2. ¦b¯Á¤ÞȨºÄ檺²Ä3¦C(§Y¸ê®ÆÅã¥Üªº¶}©l¦C)¨Ì¾Ú¸Ó®æ¤W¤èªº¤é´Á§ä¥X"ì©l¸ê®Æ" ¤¤²Ä¤@µ§¸Ó¤é´Á¸ê®Æªº¦C¸¹.
A3 = MATCH(B$1,ì©l¸ê®Æ!$A$1A$500,0)
*** E3 ¡B I3 ... ¬Ò¥iª½±µ½Æ»s¤½¦¡®M¥Î.
3. ¨Ì¦¸¼W¥[¯Á¤ÞÄ檺¦C¸¹¼Æ¦r,¨Ã¤ñ¹ï "ì©l¸ê®Æ" ¤¤¸Ó¦C¸¹ªº¤é´Á¬O§_»P¤W¤èªº¤é´Á¬Û¦P,Y¬Û¦P«hÅã¥Ü¥X¸Ó¦C¸¹,Y¤£¦P«hªí¥Ü¸Ó¤é´Á¸ê®Æ¤w§ä´M§¹²¦,¥H¤U¬Ò¤£¦AÅã¥Ü¥ô¦ó¸ê®Æ.
A4 = IF(A3="","",IF(INDIRECT(CONCATENATE("ì©l¸ê®Æ!","A",A3+1))=B$1,A3+1,""))
*** E5 ¡B I5 ... ¬Ò¥iª½±µ½Æ»s¤½¦¡®M¥Î.
*** A5 ¥H¤U¬Ò¥iª½±µ½Æ»s¤½¦¡®M¥Î.
4. ¨Ì¾Ú¯Á¤ÞÄ檺¦C¸¹¼Æ¦r¨Ì¦¸±N "¹wp¤é´Á"¡B"L O T"¡B"«È¤á"¤TÄ檺¸ê®Æ±a¥X¨Ó.
B3 = IF(A3="","",INDIRECT(CONCATENATE("ì©l¸ê®Æ!","B",A3)))
C3 = IF(A3="","",INDIRECT(CONCATENATE("ì©l¸ê®Æ!","C",A3)))
D3 = IF(A3="","",INDIRECT(CONCATENATE("ì©l¸ê®Æ!","D",A3)))
*** F3 - H3 ¡B J3 - L3 ... ¬Ò¥iª½±µ½Æ»s¤½¦¡®M¥Î.
*** B4 - D4 ¥H¤U¬Ò¥iª½±µ½Æ»s¤½¦¡®M¥Î.
5. ¤½¦¡¥u©µ¦ù¨ì¦UÄ檺²Ä70¦C, YÁÙ»Ýn©µ¦ù¥u»Ý¥H²Ä70¦C¬°¤½¦¡½d¥»,¦P®É±N¥|Ó¸ê®ÆÄæ¤@ª½½Æ»s¤U¥h(§YMark B70 ~ D70 µM«á´å¼Ð²¾¨ìD70¥k¤U¨¤,«öµÛ·Æ¹«¥ªÁ䩹¤U©Ô§Y¥i)§Y¥i.
6. ³Ì«á¦A±N "A"¡B"E" ...µ¥¯Á¤ÞÄæ "ÁôÂÃ" °_¨Ó§Y¥i.
7. ´ú¸Õ¤è¦¡ : ª½±µ×§ï "B1"¡B"F1"...µ¥Àx¦s®æªº¤ºªº¤é´Á, ©³¤U B3 - D3 ¤Î¨ä¥L "B" - "D" Ä檺ȷ|¬ÛÀ³¦ÓÅÜ.
8. ·í©óÀx¦s®æ¨Ï¥Î±a¦³¯Á¤Þ¥\¯àªº¤½¦¡®É,½Ð°È¥²°O±oì©l¸ê®Æ¤£n¦³§R°£¾ã¦C(©Î¬Y¨Ç±¡§Î¤Uªº¾ãÄæ)ªº±¡§Î,¤£µM·|¾ÉP¤½¦¡¥X²{¿ù»~.
µ{¦¡¦pªþ¥ó,½Ð°Ñ¦Ò. |
-
-
AAA_a.zip
(17.43 KB)
|